Low search order by not working
Hi there
I am using low search order by condition and passing it dynamically. But It's not working and I tried to remove some tags and found it's not sorting when I am using limit parameter. I am sorting day and field already set as number and tried with other options as well as.
I have second problem also, where I am creating custom filter but it's not returning entry_ids. See below:
public function filter($entry_ids)
{
echo "dsdssd";
print_r($entry_ids);
//print_r($rows);
die;
Although it's print dummy text but not entry_ids so please help me asap I will wait for your response.
Thanks
Replies
Low 16 Jul 2019 12:09
Not sure what you need help with? Writing a custom filter? Because that's outside of the scope of LS support.
W3care Developer 16 Jul 2019 12:18
Thanks Low for reply
I mean it's sorting is not working when I am adding limit and any extension not returning entry ids.
For filter I am checking also defined filter there no entry ids return in filter inside in filter as given belwo:
public function filter($entry_ids)
{
echo "dsdssd";
print_r($entry_ids);
//print_r($rows);
die;
above code I have checked in lsf.field_search.php
Thanks
Low 16 Jul 2019 12:22
Yes, I saw the code above, but that doesn't give me anything to work on. I'd need template code and possibly template debugger output.
If the filter doesn't get any entry IDs, then it's the first filter that's fired.
W3care Developer 16 Jul 2019 12:30
Please check
1.6258s Load
Variables
106 Queries
31.9MB Templates
Duplicate Queries (devexotr_exocms19)
13 ×
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages() #system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/assets/helpers/eeharbor_ee4_helper.php L:172 assets\EEHelper::initiateSettings() #system/phar://user/addons/wygwam/wygwam.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Wygwam\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/matrix/matrix.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Matrix\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/playa/playa.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Playa\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
2 ×
SELECT field_id, field_name FROM exp_category_fields WHERE site_id IN ('1')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:452 Channel::generateCategoryFieldSQL()
Queries (devexotr_exocms19)
0.0002s
1KB
SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0005s
13KB
SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM ('exp_modules')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0003s
13KB
SELECT 'class', 'version'
FROM ('exp_extensions')
WHERE 'enabled' = 'y'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:73 Addons_model::get_installed_extensions()
0.0002s
9KB
SELECT 'name'
FROM ('exp_fieldtypes')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0002s
9KB
SELECT 'plugin_package'
FROM ('exp_plugins')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0003s
42KB
SELECT *
FROM ('exp_sites')
WHERE 'site_id' = 1
#system/ee/legacy/libraries/Core.php L:124 EE_Config::site_prefs()
0.0004s
26KB
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:1038 EE_Extensions::__construct()
0.0018s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_detour_pro_settings')
WHERE 'exp_detour_pro_settings'.'site_id' = 1
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'detour_pro'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0008s
13KB
SELECT detour_id, original_url, new_url, detour_method, start_date, end_date
FROM exp_detours
WHERE (start_date IS NULL OR start_date = NOW())
AND 'es/trips/demo/eyJyZXN1bHRfcGFnZSI6InRyaXBzXC9kZW1vIiwic2VhcmNoX2N1c3RvbV9leG86ZGF5IjoiMSIsImNoYW5uZWwiOiJ0b3Vyc19zaWMiLCJwYXgiOiIxIiwic3VibWl0Ijoic3VibWl0In0' LIKE REPLACE(original_url, '_', '[_') ESCAPE '['
AND site_id = 1
# L: Detour_pro_ext::sessions_start()
0.0014s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0014s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_transcribe_languages')
WHERE 'abbreviation' = 'es'
# L: Transcribe_ext::transcribe_session_start()
0.0002s
11KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'site_id' = 1
LIMIT 1
#system/user/addons/transcribe/ext.transcribe.php L:2106 Transcribe::_get_settings()
0.0014s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0003s
11KB
SELECT 'ct'.'entry_id', 'ct'.'channel_id', 'tel'.'language_id', 'ct'.'url_title'
FROM ('exp_channel_titles' as ct)
JOIN 'exp_transcribe_entries_languages' as tel ON 'tel'.'entry_id' = 'ct'.'entry_id'
JOIN 'exp_structure_channels' as sc ON 'sc'.'channel_id' = 'ct'.'channel_id'
WHERE 'sc'.'type' = 'listing'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0196s
1.1MB
SELECT cr.url_title as route, cr2.url_title as relationship FROM exp_transcribe_entries_languages as tel INNER JOIN exp_transcribe_entries_languages as tel2 ON tel2.relationship_id = tel.relationship_id LEFT JOIN exp_channel_titles as cr ON cr.entry_id = tel.entry_id LEFT JOIN exp_channel_titles as cr2 ON cr2.entry_id = tel2.entry_id WHERE cr.site_id = 1
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0006s
11KB
SELECT *
FROM ('exp_modules')
WHERE 'module_name' = 'Pages'
# L: Transcribe_ext::transcribe_session_start()
0.0005s
9KB
SELECT 'var_value'
FROM ('exp_structure_settings')
WHERE 'var' = 'add_trailing_slash'
AND 'site_id' = 1
# L: Transcribe_ext::transcribe_session_start()
0.0006s
28KB
SELECT *
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (30, 31, 32, 33, 37, 3515, 3517, 3516, 3639, 3643, 3646, 46, 34, 3671, 3692, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3901, 3990, 3997, 35, 38, 40, 41, 43, 44, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3621, 3622, 3623, 3624, 3625, 3627, 3628, 3629, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3644, 3647, 3648, 36, 39, 1849, 42, 45, 47, 1904, 1905, 2968, 2969, 3059, 3060, 3085, 3518, 1, 3519, 3589, 3590, 3657, 3659, 3893, 3902, 3903, 3904, 3947, 3957, 3998, 3999, 4000, 4001, 5401, 6919, 3936, 14525, 14765, 14780, 14806, 14835, 14855, 14856, 14864, 14865, 14866, 14867, 14869, 14871, 14872, 14873, 14875, 14876, 14877, 14878, 14881, 15050, 15089, 15112, 15132, 15326, 16109, 16859, 16860, 16861, 16862, 17141, 17255, 17304, 9822, 14812, 14826, 9819, 9820, 9831, 9832, 9821, 9833, 9823, 9824, 9834, 9835, 9836, 9828, 9829, 9830, 9837, 9839, 9838, 9840, 9841, 9842, 9843, 9845, 9844, 9846, 9847, 9848, 9825, 9827, 17439, 14809, 14791, 14824, 14810, 14794, 14829, 14808, 14793, 14825, 14807, 14801, 14828, 14811, 14796, 14827, 17487, 17488, 17602, 17644, 17645, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17658, 17665, 17666, 17667, 17668, 17669, 17670, 16346, 17702, 17785, 17786, 17787, 17788, 17789, 18486, 18488, 19148, 19270, 19483, 20312, 20313, 20317, 20358, 20360, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20395, 20396, 20397, 20398, 20399, 20400, 20401, 20402, 20403, 20404, 20405, 20406, 20417, 20418, 20419, 20420, 20421, 20422, 20423, 20424, 20425, 20426, 20427, 20428, 20429, 20430, 20431, 14817, 14800, 14831, 14816, 14799, 14830, 14815, 14798, 14832, 14814, 14797, 14833, 9849, 14834, 20, 20820, 20821, 20834, 20835, 20849, 20850, 20940, 20941, 21077, 21078)
#system/user/addons/transcribe/ext.transcribe.php L:922 Transcribe::_get_language()
0.0017s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
9KB
SELECT 'abbreviation'
FROM ('exp_transcribe_languages')
#system/user/addons/transcribe/mod.transcribe.php L:1432 Transcribe::_remove_abbreviation()
0.0002s
12KB
SELECT *
FROM ('exp_structure_listings')
WHERE 'site_id' = 1
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:110 Transcribe_structure::get_listing_data()
0.0002s
9KB
SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:543 Addons_model::module_installed()
0.0002s
10KB
SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
#system/user/addons/structure/sql.structure.php L:1406 Sql_structure::get_settings()
0.0006s
9KB
SELECT site_pages FROM exp_sites WHERE site_id = 1
#system/user/addons/structure/sql.structure.php L:1420 Sql_helper::row()
0.0003s
11KB
SELECT 'entry_id', 'relationship_id', 'language_id'
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (20820, 20834, 20850, 20941, 21077)
LIMIT 999999
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:130 Transcribe_structure::get_relationship_data()
0.2345s
46KB
SELECT CONCAT_WS('/', ttgl.content, ttl.content) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT CONCAT_WS('/', tg.group_name, t.template_name) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT t.template_name as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttl.content as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttgl.content as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT tg.group_name as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1
#system/user/addons/transcribe/mod.transcribe.php L:2181 Transcribe::_get_routes()
0.0016s
3KB
SHOW TABLES LIKE "%structure%"
# L: Transcribe_ext::transcribe_session_start()
0.0004s
14KB
SELECT * FROM exp_extensions WHERE class='Freebie_ext'
#system/user/addons/freebie/ext.freebie.php L:93 Freebie_ext::clear_cache()
0.0016s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
9KB
SELECT entry_id FROM exp_structure_listings WHERE site_id = 1 LIMIT 99999999
#system/user/addons/structure/sql.structure.php L:1194 Sql_structure::get_listing_entry_ids()
0.0002s
13KB
SELECT *
FROM ('exp_remember_me')
WHERE 'remember_me_id' = 'b6b1b86c39d69f295802ee71402610f172547c5c'
#system/ee/legacy/libraries/Remember.php L:99 Remember::_validate_db()
0.0008s
13KB
SELECT 'member_id', 'can_debug', 'admin_sess', 'last_activity', 'fingerprint', 'sess_start', 'login_state'
FROM ('exp_sessions')
WHERE 'session_id' = '7a5e72f4825b5a6cf3ea1528ca444a6ed3558352'
#system/ee/legacy/libraries/Session.php L:161 EE_Session::fetch_session_data()
0.0006s
123KB
SELECT *
FROM ('exp_members' m, 'exp_member_groups' g)
WHERE 'g'.'site_id' = 1
AND m.group_id = g.group_id
AND 'member_id' = 10
#system/ee/legacy/libraries/Session.php L:558 EE_Session::_do_member_query()
0.0006s
2KB
UPDATE 'exp_sessions' SET 'session_id' = '7a5e72f4825b5a6cf3ea1528ca444a6ed3558352', 'fingerprint' = '5d217aaff3e5d30543f46db0b9252677', 'member_id' = 10, 'admin_sess' = 1, 'ip_address' = '103.137.84.193', 'user_agent' = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0', 'last_activity' = 1563280071, 'sess_start' = 1563278513, 'can_debug' = 'n' WHERE session_id = '7a5e72f4825b5a6cf3ea1528ca444a6ed3558352'
#system/ee/legacy/libraries/Session.php L:177 EE_Session::update_session()
0.0015s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_security_hashes')
WHERE 'session_id' = '7a5e72f4825b5a6cf3ea1528ca444a6ed3558352'
#system/ee/legacy/libraries/Csrf.php L:161 Csrf_database::fetch_token()
0.0005s
47KB
SELECT Snippet_snippets.snippet_id as Snippet__snippet_id, Snippet_snippets.site_id as Snippet__site_id, Snippet_snippets.snippet_name as Snippet__snippet_name, Snippet_snippets.snippet_contents as Snippet__snippet_contents, Snippet_snippets.edit_date as Snippet__edit_date
FROM ('exp_snippets' as Snippet_snippets)
WHERE (
'Snippet_snippets'.'site_id' = 1
OR 'Snippet_snippets'.'site_id' = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Core.php L:370 EllisLab\ExpressionEngine\Model\Template\Snippet::loadAll()
0.0004s
10KB
SELECT Site_sites.site_id as Site__site_id, Site_sites.site_name as Site__site_name
FROM ('exp_sites' as Site_sites)
WHERE (
'Site_sites'.'site_id' = 1
)
LIMIT 1
#system/ee/EllisLab/ExpressionEngine/Model/Template/Snippet.php L:168 EllisLab\ExpressionEngine\Model\Template\Snippet::getFolderPath()
0.0015s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0006s
11KB
SELECT 'route_parsed', 'template_name', 'group_name'
FROM ('exp_templates')
JOIN 'exp_template_routes' ON 'exp_templates'.'template_id' = 'exp_template_routes'.'template_id'
JOIN 'exp_template_groups' ON 'exp_templates'.'group_id' = 'exp_template_groups'.'group_id'
WHERE 'route_parsed' is not null
AND 'exp_templates'.'site_id' = 1
ORDER BY 'order', 'group_name', 'template_name' ASC
#system/ee/legacy/libraries/Template_router.php L:24 EE_Template_Router::set_routes()
0.0002s
9KB
SELECT 'group_id'
FROM ('exp_template_groups')
WHERE 'group_name' = 'trips'
AND 'site_id' = 1
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0004s
9KB
SELECT COUNT(*) as count
FROM ('exp_templates')
WHERE 'group_id' = 29
AND 'template_name' = 'demo'
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0007s
20KB
SELECT 'exp_templates'.*, 'exp_template_groups'.'group_name'
FROM ('exp_templates')
JOIN 'exp_template_groups' ON 'exp_template_groups'.'group_id' = 'exp_templates'.'group_id'
WHERE 'exp_template_groups'.'site_id' = 1
AND 'exp_templates'.'template_name' = 'demo'
AND 'exp_template_groups'.'group_name' = 'trips'
#system/ee/legacy/libraries/Template.php L:2412 EE_Template::fetch_template()
0.0003s
13KB
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM ('exp_plugins' as Plugin_plugins)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:1454 EE_Template::fetch_addons()
0.0002s
10KB
SELECT 'module_version', 'module_name'
FROM ('exp_modules')
#system/ee/legacy/libraries/Template.php L:1478 EE_Template::process_tags()
0.0003s
9KB
SELECT 'settings'
FROM ('exp_extensions')
WHERE 'class' = 'Low_search_ext'
LIMIT 1
#system/user/addons/low_search/libraries/Low_search_params.php L:148 Low_search_settings::get()
0.0003s
11KB
SELECT 'channel_id', 'channel_name', 'search_excerpt', IF(search_results_url='', channel_url, search_results_url) AS url
FROM ('exp_channels')
WHERE 'site_id' IN (1, 0)
AND 'channel_name' IN ('tours_sic')
#system/user/addons/low_search/filters/keywords/lsf.keywords.php L:127 Low_search_filter_keywords::_no_keywords()
0.0008s
39KB
SELECT 'field_id', 'field_type', 'field_fmt', 'field_name', 'site_id', 'field_settings'
FROM ('exp_channel_fields')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:362 Api_channel_fields::fetch_custom_channel_fields()
0.0007s
9KB
SELECT Site_sites.site_id as Site__site_id
FROM ('exp_sites' as Site_sites)
LIMIT 18446744073709551615
#system/ee/EllisLab/Addons/channel/mod.channel.php L:155 Channel::fetch_custom_channel_fields()
0.0002s
9KB
SELECT channel_id FROM exp_channels WHERE channel_name = 'tours_sic'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0003s
29KB
SELECT ChannelField_channel_fields.field_id as ChannelField__field_id, ChannelField_channel_fields.site_id as ChannelField__site_id, ChannelField_channel_fields.field_name as ChannelField__field_name, ChannelField_channel_fields.field_label as ChannelField__field_label, ChannelField_channel_fields.field_instructions as ChannelField__field_instructions, ChannelField_channel_fields.field_type as ChannelField__field_type, ChannelField_channel_fields.field_list_items as ChannelField__field_list_items, ChannelField_channel_fields.field_pre_populate as ChannelField__field_pre_populate, ChannelField_channel_fields.field_pre_channel_id as ChannelField__field_pre_channel_id, ChannelField_channel_fields.field_pre_field_id as ChannelField__field_pre_field_id, ChannelField_channel_fields.field_ta_rows as ChannelField__field_ta_rows, ChannelField_channel_fields.field_maxl as ChannelField__field_maxl, ChannelField_channel_fields.field_required as ChannelField__field_required, ChannelField_channel_fields.field_text_direction as ChannelField__field_text_direction, ChannelField_channel_fields.field_search as ChannelField__field_search, ChannelField_channel_fields.field_is_hidden as ChannelField__field_is_hidden, ChannelField_channel_fields.field_fmt as ChannelField__field_fmt, ChannelField_channel_fields.field_show_fmt as ChannelField__field_show_fmt, ChannelField_channel_fields.field_order as ChannelField__field_order, ChannelField_channel_fields.field_content_type as ChannelField__field_content_type, ChannelField_channel_fields.field_settings as ChannelField__field_settings, ChannelField_channel_fields.legacy_field_data as ChannelField__legacy_field_data
FROM ('exp_channel_fields' as ChannelField_channel_fields)
WHERE (
'ChannelField_channel_fields'.'field_id' = 868
)
LIMIT 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0017s
11KB
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_channel_data_field_868 ON exp_channel_data_field_868.entry_id = t.entry_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date < 1563280071 AND (t.expiration_date = 0 OR t.expiration_date > 1563280071) AND t.channel_id IN (58) AND t.status != 'closed'ORDER BY t.sticky desc, exp_channel_data_field_868.field_id_868 desc, t.entry_id desc LIMIT 0, 12
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0008s
122KB
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.extra_publish_controls as Channel__extra_publish_controls, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.
Low 16 Jul 2019 12:34
What template code isn't giving you the expected results?
W3care Developer 16 Jul 2019 12:40
yes it's not sorting and not getting entry ids either in filter or extension
Low 16 Jul 2019 12:42
No, I'm asking for template code.
So something like {exp:low_search:results ... }
What are the template tags that you're using that aren't giving you the sorted results that you expect?
W3care Developer 16 Jul 2019 12:46
Result is
Indochina Étnica----12
El Gran tour del Sudeste Asiático----17
Indochina al completo----16
Bangkok, Siem Reap y Vietnam----15
Tailandia y Vietnam al completo----15
Rutas de Indochina----15
Singapur, Bagan, Angkor y Bangkok----13
Singapur, Vietnam, Camboya y Tailandia----13
Vietnam, Camboya y Tailandia----13
Lo mejor de Bangkok y Vietnam----13
Lo mejor de Indochina----13
Vietnam, Camboya, los esenciales----13
Below is result template and code copy from same template:
{exp:low_search:results
orderby_sort="tours_sic_number_of_days|desc"
channel="tours_sic"
disable="member_data"
status="not closed"
paginate="bottom"
limit="12"
}
{title}----{tours_sic_number_of_days}
{/exp:low_search:results}
Low 16 Jul 2019 13:02
Okay, as far as I can see, Low Search doesn't do any filtering, because there aren't any filter-parameters set in the Results tag.
The queries in the debugger confirm this; LS isn't running any queries to filter entries.
So, LS only sets some parameters and then calls the channel:entries tag to render the output. Here, it only transforms orderby_sort="tours_sic_number_of_days|desc" to orderby="tours_sic_number_of_days" sort="desc"
From the debugger, I can see you have Transcribe installed. Maybe that's messing things up. As far as I can see, LS is working as expected.
What happens if you use this instead?
{exp:channel:entries
orderby="tours_sic_number_of_days"
sort="desc"
channel="tours_sic"
disable="member_data"
status="not closed"
paginate="bottom"
limit="12"
}
W3care Developer 16 Jul 2019 13:13
Ok , I have changed with below code but still not getting sorting result
{exp:low_search:results
query="{segment_3}"
channel="tours_sic"
disable="member_data"
status="not closed"
orderby="tours_sic_number_of_days"
sort="desc"
paginate="bottom"
limit="12"
}
======================================
Multisport Angkok Hike and Bike Hike and Angkok----12
Multisport Angkok Hike and Bike Hike and Angkok----1
Multisport Angkok Hike and Bike Hike and Angkok----12
Multisport Angkok Hike and Bike Hike and Angkok----2
Through the Mekong, Ho Chi Minh to Phnom Penh10----7
Multisport Angkok Hike and Bike Hike and Angkok----3
demo tour----10
Exo Trip----8
Through the Mekong, Ho Chi Minh to Phnom Penh----65
1.4458s Load
Variables
109 Queries
30.6MB Templates
Duplicate Queries (devexotr_exocms19)
13 ×
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages() #system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings() #system/user/addons/assets/helpers/eeharbor_ee4_helper.php L:172 assets\EEHelper::initiateSettings() #system/phar://user/addons/wygwam/wygwam.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Wygwam\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/playa/playa.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Playa\FluxCapacitor\Bridge\EE4::initiateSettings() #system/phar://user/addons/matrix/matrix.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Matrix\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
4 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
3 ×
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
2 ×
SELECT field_id, field_name FROM exp_category_fields WHERE site_id IN ('1')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:452 Channel::generateCategoryFieldSQL()
Queries (devexotr_exocms19)
0.0002s
1KB
SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0003s
13KB
SELECT LOWER(module_name) AS module_name, module_version, has_cp_backend, module_id
FROM ('exp_modules')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:56 Addons_model::get_installed_modules()
0.0003s
13KB
SELECT 'class', 'version'
FROM ('exp_extensions')
WHERE 'enabled' = 'y'
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Addon.php L:73 Addons_model::get_installed_extensions()
0.0002s
9KB
SELECT 'name'
FROM ('exp_fieldtypes')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0002s
9KB
SELECT 'plugin_package'
FROM ('exp_plugins')
#system/ee/EllisLab/ExpressionEngine/Service/Addon/Factory.php L:84 EllisLab\ExpressionEngine\Service\Addon\Addon::isInstalled()
0.0003s
42KB
SELECT *
FROM ('exp_sites')
WHERE 'site_id' = 1
#system/ee/legacy/libraries/Core.php L:124 EE_Config::site_prefs()
0.0004s
26KB
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:1038 EE_Extensions::__construct()
0.0002s
9KB
SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Blacklist'
#system/ee/legacy/libraries/Blacklist.php L:58 Addons_model::module_installed()
0.0002s
10KB
SELECT whitelisted_type, whitelisted_value FROM exp_whitelisted
WHERE whitelisted_value != ''
#system/ee/legacy/libraries/Core.php L:283 EE_Blacklist::_check_blacklist()
0.0002s
9KB
SELECT blacklisted_type, blacklisted_value FROM exp_blacklisted
#system/ee/legacy/libraries/Core.php L:283 EE_Blacklist::_check_blacklist()
0.0017s
25KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_detour_pro_settings')
WHERE 'exp_detour_pro_settings'.'site_id' = 1
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'detour_pro'
#system/phar://user/addons/detour_pro/detour_pro.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\DetourPro\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0007s
13KB
SELECT detour_id, original_url, new_url, detour_method, start_date, end_date
FROM exp_detours
WHERE (start_date IS NULL OR start_date = NOW())
AND 'en/trips/demo/eyJyZXN1bHRfcGFnZSI6InRyaXBzXC9kZW1vIiwiY2hhbm5lbCI6InRvdXJzX3NpYyIsInBheCI6IjEiLCJzdWJtaXQiOiJzdWJtaXQifQ' LIKE REPLACE(original_url, '_', '[_') ESCAPE '['
AND site_id = 1
# L: Detour_pro_ext::sessions_start()
0.0013s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0013s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_transcribe_languages')
WHERE 'abbreviation' = 'en'
# L: Transcribe_ext::transcribe_session_start()
0.0002s
11KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'site_id' = 1
LIMIT 1
#system/user/addons/transcribe/ext.transcribe.php L:2106 Transcribe::_get_settings()
0.0013s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0003s
11KB
SELECT 'ct'.'entry_id', 'ct'.'channel_id', 'tel'.'language_id', 'ct'.'url_title'
FROM ('exp_channel_titles' as ct)
JOIN 'exp_transcribe_entries_languages' as tel ON 'tel'.'entry_id' = 'ct'.'entry_id'
JOIN 'exp_structure_channels' as sc ON 'sc'.'channel_id' = 'ct'.'channel_id'
WHERE 'sc'.'type' = 'listing'
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0150s
1.1MB
SELECT cr.url_title as route, cr2.url_title as relationship FROM exp_transcribe_entries_languages as tel INNER JOIN exp_transcribe_entries_languages as tel2 ON tel2.relationship_id = tel.relationship_id LEFT JOIN exp_channel_titles as cr ON cr.entry_id = tel.entry_id LEFT JOIN exp_channel_titles as cr2 ON cr2.entry_id = tel2.entry_id WHERE cr.site_id = 1
#system/user/addons/transcribe/ext.transcribe.php L:833 Transcribe::_fix_structure_site_pages()
0.0003s
11KB
SELECT *
FROM ('exp_modules')
WHERE 'module_name' = 'Pages'
# L: Transcribe_ext::transcribe_session_start()
0.0003s
9KB
SELECT 'var_value'
FROM ('exp_structure_settings')
WHERE 'var' = 'add_trailing_slash'
AND 'site_id' = 1
# L: Transcribe_ext::transcribe_session_start()
0.0005s
28KB
SELECT *
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (30, 31, 32, 33, 37, 3515, 3517, 3516, 3639, 3643, 3646, 46, 34, 3671, 3692, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3901, 3990, 3997, 35, 38, 40, 41, 43, 44, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3621, 3622, 3623, 3624, 3625, 3627, 3628, 3629, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3644, 3647, 3648, 36, 39, 1849, 42, 45, 47, 1904, 1905, 2968, 2969, 3059, 3060, 3085, 3518, 1, 3519, 3589, 3590, 3657, 3659, 3893, 3902, 3903, 3904, 3947, 3957, 3998, 3999, 4000, 4001, 5401, 6919, 3936, 14525, 14765, 14780, 14806, 14835, 14855, 14856, 14864, 14865, 14866, 14867, 14869, 14871, 14872, 14873, 14875, 14876, 14877, 14878, 14881, 15050, 15089, 15112, 15132, 15326, 16109, 16859, 16860, 16861, 16862, 17141, 17255, 17304, 9822, 14812, 14826, 9819, 9820, 9831, 9832, 9821, 9833, 9823, 9824, 9834, 9835, 9836, 9828, 9829, 9830, 9837, 9839, 9838, 9840, 9841, 9842, 9843, 9845, 9844, 9846, 9847, 9848, 9825, 9827, 17439, 14809, 14791, 14824, 14810, 14794, 14829, 14808, 14793, 14825, 14807, 14801, 14828, 14811, 14796, 14827, 17487, 17488, 17602, 17644, 17645, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17658, 17665, 17666, 17667, 17668, 17669, 17670, 16346, 17702, 17785, 17786, 17787, 17788, 17789, 18486, 18488, 19148, 19270, 19483, 20312, 20313, 20317, 20358, 20360, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20395, 20396, 20397, 20398, 20399, 20400, 20401, 20402, 20403, 20404, 20405, 20406, 20417, 20418, 20419, 20420, 20421, 20422, 20423, 20424, 20425, 20426, 20427, 20428, 20429, 20430, 20431, 14817, 14800, 14831, 14816, 14799, 14830, 14815, 14798, 14832, 14814, 14797, 14833, 9849, 14834, 20, 20820, 20821, 20834, 20835, 20849, 20850, 20940, 20941, 21077, 21078)
#system/user/addons/transcribe/ext.transcribe.php L:922 Transcribe::_get_language()
0.0016s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
12KB
SELECT *
FROM ('exp_transcribe_settings')
WHERE 'exp_transcribe_settings'.'site_id' = 1
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'transcribe'
#system/phar://user/addons/transcribe/transcribe.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Transcribe\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'abbreviation'
FROM ('exp_transcribe_languages')
#system/user/addons/transcribe/mod.transcribe.php L:1432 Transcribe::_remove_abbreviation()
0.0002s
12KB
SELECT *
FROM ('exp_structure_listings')
WHERE 'site_id' = 1
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:110 Transcribe_structure::get_listing_data()
0.0002s
9KB
SELECT COUNT(*) AS 'numrows'
FROM ('exp_modules')
WHERE 'module_name' = 'Structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:543 Addons_model::module_installed()
0.0002s
10KB
SELECT var_value, var FROM exp_structure_settings WHERE site_id IN (0,1)
#system/user/addons/structure/sql.structure.php L:1406 Sql_structure::get_settings()
0.0002s
9KB
SELECT site_pages FROM exp_sites WHERE site_id = 1
#system/user/addons/structure/sql.structure.php L:1420 Sql_helper::row()
0.0004s
25KB
SELECT 'entry_id', 'relationship_id', 'language_id'
FROM ('exp_transcribe_entries_languages')
WHERE 'entry_id' IN (30, 31, 32, 33, 37, 3515, 3517, 3516, 3639, 3643, 3646, 46, 34, 3671, 3692, 3797, 3798, 3799, 3800, 3801, 3802, 3803, 3804, 3805, 3894, 3895, 3896, 3897, 3898, 3899, 3900, 3901, 3990, 3997, 35, 38, 40, 41, 43, 44, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3621, 3622, 3623, 3624, 3625, 3627, 3628, 3629, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3644, 3647, 3648, 36, 39, 1849, 42, 45, 47, 1904, 1905, 2968, 2969, 3059, 3060, 3085, 3518, 1, 3519, 3589, 3590, 3657, 3659, 3893, 3902, 3903, 3904, 3947, 3957, 3998, 3999, 4000, 4001, 5401, 6919, 3936, 14525, 14765, 14780, 14806, 14835, 14855, 14856, 14864, 14865, 14866, 14867, 14869, 14871, 14872, 14873, 14875, 14876, 14877, 14878, 14881, 15050, 15089, 15112, 15132, 15326, 16109, 16859, 16860, 16861, 16862, 17141, 17255, 17304, 9822, 14812, 14826, 9819, 9820, 9831, 9832, 9821, 9833, 9823, 9824, 9834, 9835, 9836, 9828, 9829, 9830, 9837, 9839, 9838, 9840, 9841, 9842, 9843, 9845, 9844, 9846, 9847, 9848, 9825, 9827, 17439, 14809, 14791, 14824, 14810, 14794, 14829, 14808, 14793, 14825, 14807, 14801, 14828, 14811, 14796, 14827, 17487, 17488, 17602, 17644, 17645, 17648, 17649, 17650, 17651, 17652, 17653, 17654, 17655, 17658, 17665, 17666, 17667, 17668, 17669, 17670, 16346, 17702, 17785, 17786, 17787, 17788, 17789, 18486, 18488, 19148, 19270, 19483, 20312, 20313, 20317, 20358, 20360, 20376, 20377, 20378, 20379, 20380, 20381, 20382, 20384, 20385, 20386, 20387, 20388, 20389, 20390, 20391, 20392, 20395, 20396, 20397, 20398, 20399, 20400, 20401, 20402, 20403, 20404, 20405, 20406, 20417, 20418, 20419, 20420, 20421, 20422, 20423, 20424, 20425, 20426, 20427, 20428, 20429, 20430, 20431, 14817, 14800, 14831, 14816, 14799, 14830, 14815, 14798, 14832, 14814, 14797, 14833, 9849, 14834, 20, 20821, 20835, 20849, 20940)
LIMIT 999999
#system/user/addons/transcribe/libraries/Transcribe_structure.php L:130 Transcribe_structure::get_relationship_data()
0.2260s
46KB
SELECT CONCAT_WS('/', ttgl.content, ttl.content) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT CONCAT_WS('/', tg.group_name, t.template_name) as route, CONCAT_WS('/', tg.group_name, t.template_name) as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT t.template_name as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttl.content as route, t.template_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE tg.is_site_default = 'y' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT ttgl.content as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id JOIN exp_transcribe_template_groups_languages as ttgl ON ttgl.template_group_id = tg.group_id JOIN exp_transcribe_templates_languages as ttl ON ttl.template_id = t.template_id AND ttl.language_id = ttgl.language_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1 UNION ALL SELECT tg.group_name as route, tg.group_name as relationship FROM exp_template_groups as tg JOIN exp_templates as t ON t.group_id = tg.group_id WHERE t.template_name = 'index' AND tg.site_id = 1 AND t.site_id = 1
#system/user/addons/transcribe/mod.transcribe.php L:2181 Transcribe::_get_routes()
0.0013s
3KB
SHOW TABLES LIKE "%structure%"
# L: Transcribe_ext::transcribe_session_start()
0.0004s
14KB
SELECT * FROM exp_extensions WHERE class='Freebie_ext'
#system/user/addons/freebie/ext.freebie.php L:93 Freebie_ext::clear_cache()
0.0017s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0003s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT entry_id FROM exp_structure_listings WHERE site_id = 1 LIMIT 99999999
#system/user/addons/structure/sql.structure.php L:1194 Sql_structure::get_listing_entry_ids()
0.0002s
13KB
SELECT *
FROM ('exp_remember_me')
WHERE 'remember_me_id' = 'b6b1b86c39d69f295802ee71402610f172547c5c'
#system/ee/legacy/libraries/Remember.php L:99 Remember::_validate_db()
0.0005s
13KB
SELECT 'member_id', 'can_debug', 'admin_sess', 'last_activity', 'fingerprint', 'sess_start', 'login_state'
FROM ('exp_sessions')
WHERE 'session_id' = '42b6232edf3e34a0f99a2cb63a261e1dc27a82c6'
#system/ee/legacy/libraries/Session.php L:161 EE_Session::fetch_session_data()
0.0006s
123KB
SELECT *
FROM ('exp_members' m, 'exp_member_groups' g)
WHERE 'g'.'site_id' = 1
AND m.group_id = g.group_id
AND 'member_id' = 10
#system/ee/legacy/libraries/Session.php L:558 EE_Session::_do_member_query()
0.0003s
2KB
UPDATE 'exp_sessions' SET 'session_id' = '42b6232edf3e34a0f99a2cb63a261e1dc27a82c6', 'fingerprint' = '5d217aaff3e5d30543f46db0b9252677', 'member_id' = 10, 'admin_sess' = 1, 'ip_address' = '103.137.84.193', 'user_agent' = 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0', 'last_activity' = 1563282703, 'sess_start' = 1563282512, 'can_debug' = 'n' WHERE session_id = '42b6232edf3e34a0f99a2cb63a261e1dc27a82c6'
#system/ee/legacy/libraries/Session.php L:177 EE_Session::update_session()
0.0014s
23KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_security_hashes')
WHERE 'session_id' = '42b6232edf3e34a0f99a2cb63a261e1dc27a82c6'
#system/ee/legacy/libraries/Csrf.php L:161 Csrf_database::fetch_token()
0.0006s
47KB
SELECT Snippet_snippets.snippet_id as Snippet__snippet_id, Snippet_snippets.site_id as Snippet__site_id, Snippet_snippets.snippet_name as Snippet__snippet_name, Snippet_snippets.snippet_contents as Snippet__snippet_contents, Snippet_snippets.edit_date as Snippet__edit_date
FROM ('exp_snippets' as Snippet_snippets)
WHERE (
'Snippet_snippets'.'site_id' = 1
OR 'Snippet_snippets'.'site_id' = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Core.php L:370 EllisLab\ExpressionEngine\Model\Template\Snippet::loadAll()
0.0002s
10KB
SELECT Site_sites.site_id as Site__site_id, Site_sites.site_name as Site__site_name
FROM ('exp_sites' as Site_sites)
WHERE (
'Site_sites'.'site_id' = 1
)
LIMIT 1
#system/ee/EllisLab/ExpressionEngine/Model/Template/Snippet.php L:168 EllisLab\ExpressionEngine\Model\Template\Snippet::getFolderPath()
0.0014s
24KB
SHOW TABLES FROM 'devexotr_exocms19'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
11KB
SELECT *
FROM ('exp_structure_settings')
WHERE 'exp_structure_settings'.'site_id' = 1
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_fieldtypes')
WHERE 'name' = 'structure'
#system/phar://user/addons/structure/structure.phar/FluxCapacitor/Bridge/EE4.php L:218 EEHarbor\Structure\FluxCapacitor\Bridge\EE4::initiateSettings()
0.0005s
11KB
SELECT 'route_parsed', 'template_name', 'group_name'
FROM ('exp_templates')
JOIN 'exp_template_routes' ON 'exp_templates'.'template_id' = 'exp_template_routes'.'template_id'
JOIN 'exp_template_groups' ON 'exp_templates'.'group_id' = 'exp_template_groups'.'group_id'
WHERE 'route_parsed' is not null
AND 'exp_templates'.'site_id' = 1
ORDER BY 'order', 'group_name', 'template_name' ASC
#system/ee/legacy/libraries/Template_router.php L:24 EE_Template_Router::set_routes()
0.0002s
9KB
SELECT 'group_id'
FROM ('exp_template_groups')
WHERE 'group_name' = 'trips'
AND 'site_id' = 1
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0004s
9KB
SELECT COUNT(*) as count
FROM ('exp_templates')
WHERE 'group_id' = 29
AND 'template_name' = 'demo'
#system/ee/legacy/libraries/Template.php L:211 EE_Template::parse_template_uri()
0.0009s
20KB
SELECT 'exp_templates'.*, 'exp_template_groups'.'group_name'
FROM ('exp_templates')
JOIN 'exp_template_groups' ON 'exp_template_groups'.'group_id' = 'exp_templates'.'group_id'
WHERE 'exp_template_groups'.'site_id' = 1
AND 'exp_templates'.'template_name' = 'demo'
AND 'exp_template_groups'.'group_name' = 'trips'
#system/ee/legacy/libraries/Template.php L:2412 EE_Template::fetch_template()
0.0003s
13KB
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM ('exp_plugins' as Plugin_plugins)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:1454 EE_Template::fetch_addons()
0.0002s
10KB
SELECT 'module_version', 'module_name'
FROM ('exp_modules')
#system/ee/legacy/libraries/Template.php L:1478 EE_Template::process_tags()
0.0002s
9KB
SELECT 'settings'
FROM ('exp_extensions')
WHERE 'class' = 'Low_search_ext'
LIMIT 1
#system/user/addons/low_search/libraries/Low_search_params.php L:148 Low_search_settings::get()
0.0003s
11KB
SELECT 'channel_id', 'channel_name', 'search_excerpt', IF(search_results_url='', channel_url, search_results_url) AS url
FROM ('exp_channels')
WHERE 'site_id' IN (1, 0)
AND 'channel_name' IN ('tours_sic')
#system/user/addons/low_search/filters/keywords/lsf.keywords.php L:127 Low_search_filter_keywords::_no_keywords()
0.0007s
39KB
SELECT 'field_id', 'field_type', 'field_fmt', 'field_name', 'site_id', 'field_settings'
FROM ('exp_channel_fields')
#system/ee/EllisLab/Addons/channel/mod.channel.php L:362 Api_channel_fields::fetch_custom_channel_fields()
0.0003s
9KB
SELECT Site_sites.site_id as Site__site_id
FROM ('exp_sites' as Site_sites)
LIMIT 18446744073709551615
#system/ee/EllisLab/Addons/channel/mod.channel.php L:155 Channel::fetch_custom_channel_fields()
0.0002s
9KB
SELECT channel_id FROM exp_channels WHERE channel_name = 'tours_sic'
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0006s
29KB
SELECT ChannelField_channel_fields.field_id as ChannelField__field_id, ChannelField_channel_fields.site_id as ChannelField__site_id, ChannelField_channel_fields.field_name as ChannelField__field_name, ChannelField_channel_fields.field_label as ChannelField__field_label, ChannelField_channel_fields.field_instructions as ChannelField__field_instructions, ChannelField_channel_fields.field_type as ChannelField__field_type, ChannelField_channel_fields.field_list_items as ChannelField__field_list_items, ChannelField_channel_fields.field_pre_populate as ChannelField__field_pre_populate, ChannelField_channel_fields.field_pre_channel_id as ChannelField__field_pre_channel_id, ChannelField_channel_fields.field_pre_field_id as ChannelField__field_pre_field_id, ChannelField_channel_fields.field_ta_rows as ChannelField__field_ta_rows, ChannelField_channel_fields.field_maxl as ChannelField__field_maxl, ChannelField_channel_fields.field_required as ChannelField__field_required, ChannelField_channel_fields.field_text_direction as ChannelField__field_text_direction, ChannelField_channel_fields.field_search as ChannelField__field_search, ChannelField_channel_fields.field_is_hidden as ChannelField__field_is_hidden, ChannelField_channel_fields.field_fmt as ChannelField__field_fmt, ChannelField_channel_fields.field_show_fmt as ChannelField__field_show_fmt, ChannelField_channel_fields.field_order as ChannelField__field_order, ChannelField_channel_fields.field_content_type as ChannelField__field_content_type, ChannelField_channel_fields.field_settings as ChannelField__field_settings, ChannelField_channel_fields.legacy_field_data as ChannelField__legacy_field_data
FROM ('exp_channel_fields' as ChannelField_channel_fields)
WHERE (
'ChannelField_channel_fields'.'field_id' = 868
)
LIMIT 1
#system/ee/EllisLab/Addons/channel/mod.channel.php L:248 Channel::build_sql_query()
0.0023s
11KB
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id LEFT JOIN exp_channel_data_field_868 ON exp_channel_data_field_868.entry_id = t.entry_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date < 1563282703 AND (t.expiration_date = 0 OR t.expiration_date > 156
Low 16 Jul 2019 13:23
Does this give you the correct sorting results?
{exp:channel:entries
channel="tours_sic"
status="not closed"
orderby="tours_sic_number_of_days"
sort="desc"
paginate="bottom"
limit="12"
}
{title}----{tours_sic_number_of_days}
{/exp:channel:entries}
W3care Developer 16 Jul 2019 13:30
No it's also giving random ordering but when I am removing limit then giving correct results
Low 16 Jul 2019 13:31
That confirms that it's not a Low Search issue. I suggest you ask EllisLab to get this resolved.
W3care Developer 17 Jul 2019 04:06
Ok thanks I will check and contact you if anything needed