SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`media_id` AS `t0_c1`, `seafari_t0`.`name` AS `t0_c2`, `seafari_t0`.`slug` AS `t0_c3`, `seafari_t0`.`description` AS `t0_c4`, `seafari_t0`.`status` AS `t0_c5`, `seafari_t0`.`hash` AS `t0_c6`, `seafari_t0`.`created_at` AS `t0_c7`, `seafari_t0`.`updated_at` AS `t0_c8` FROM `seafari_celebrities` AS `seafari_t0` WHERE `seafari_t0`.`status` = 'live' ORDER BY RAND() ASC LIMIT 4Connection name: default Speed: 0.565 ms Query analysis: · Query: SIMPLE on seafari_t0 · Type: ALL · Rows: 5 (Using where; Using temporary; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: APPPATH/classes/controller/public.php, line 120File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 27File: COREPATH/classes/request.php, line 441File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`module_folder` AS `t0_c1`, `seafari_t0`.`slug` AS `t0_c2`, `seafari_t0`.`title` AS `t0_c3`, `seafari_t0`.`description` AS `t0_c4`, `seafari_t0`.`icon` AS `t0_c5` FROM `seafari_widgets` AS `seafari_t0` WHERE `seafari_t0`.`slug` IN ('pages', 'formulaire_contact', 'gallery', 'boats', 'tours', 'employees', 'cruises')Connection name: default Speed: 0.361 ms Query analysis: · Query: SIMPLE on seafari_t0 · Type: ALL · Rows: 15 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: /var/www/frameworks/fuelphp/proxapps/modules/widgets/classes/model/widget/instance.php, line 128File: COREPATH/classes/autoloader.php, line 375File: COREPATH/classes/autoloader.php, line 269File: APPPATH/classes/controller/public.php, line 124File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 27File: COREPATH/classes/request.php, line 441File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`title` AS `t0_c1`, `seafari_t0`.`area_id` AS `t0_c2`, `seafari_t0`.`widget_id` AS `t0_c3`, `seafari_t0`.`hash_mod` AS `t0_c4`, `seafari_t0`.`options` AS `t0_c5`, `seafari_t0`.`order` AS `t0_c6`, `seafari_t0`.`created_at` AS `t0_c7`, `seafari_t0`.`updated_at` AS `t0_c8` FROM `seafari_widget_instances` AS `seafari_t0` WHERE `seafari_t0`.`hash_mod` = '' ORDER BY `seafari_t0`.`order` ASCConnection name: default Speed: 0.339 ms Query analysis: · Query: SIMPLE on seafari_t0 · Type: ALL · Rows: 83 (Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: APPPATH/classes/controller/public.php, line 124File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 27File: COREPATH/classes/request.php, line 441File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`uri` = 'croisieres-plongee/egypte/promos' ORDER BY `seafari_t0`.`id` ASC LIMIT 1Connection name: default Speed: 0.734 ms Query analysis: · Query: SIMPLE on seafari_t0 · Key Used: PRIMARY · Type: index · Rows: 1 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model.php, line 584File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 77File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '8' AND `seafari_t0`.`right_id` > '9' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.916 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: right_id · Type: range · Rows: 41 (Using index condition; Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 90File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '3' AND `seafari_t0`.`right_id` > '42' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.469 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 4 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 90File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '2' AND `seafari_t0`.`right_id` > '73' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.342 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 2 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 90File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '1' AND `seafari_t0`.`right_id` > '118' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.262 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 1 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 90File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` > '2' AND `seafari_t0`.`right_id` < '73' ORDER BY `seafari_t0`.`left_id` ASCConnection name: default Speed: 0.528 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Type: ALL · Rows: 47 (Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: PKGPATH/orm/classes/model/nestedset.php, line 811File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 101File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`title` AS `t0_c1`, `seafari_t0`.`area_id` AS `t0_c2`, `seafari_t0`.`widget_id` AS `t0_c3`, `seafari_t0`.`hash_mod` AS `t0_c4`, `seafari_t0`.`options` AS `t0_c5`, `seafari_t0`.`order` AS `t0_c6`, `seafari_t0`.`created_at` AS `t0_c7`, `seafari_t0`.`updated_at` AS `t0_c8` FROM `seafari_widget_instances` AS `seafari_t0` WHERE `seafari_t0`.`hash_mod` = 'a35986c8cf0c3a7f27037f104e17c85a' ORDER BY `seafari_t0`.`order` ASCConnection name: default Speed: 0.330 ms Query analysis: · Query: SIMPLE on seafari_t0 · Type: ALL · Rows: 83 (Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model/nestedset.php, line 1315File: PKGPATH/orm/classes/model.php, line 980File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 117File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '8' AND `seafari_t0`.`right_id` > '9' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.319 ms · DUPLICATE Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: right_id · Type: range · Rows: 41 (Using index condition; Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: PKGPATH/orm/classes/model/nestedset.php, line 1586File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 168File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '3' AND `seafari_t0`.`right_id` > '42' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.273 ms · DUPLICATE Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 4 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: PKGPATH/orm/classes/model/nestedset.php, line 1586File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 168File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '2' AND `seafari_t0`.`right_id` > '73' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.202 ms · DUPLICATE Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 2 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: PKGPATH/orm/classes/model/nestedset.php, line 1586File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 168File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`title` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`intro` AS `t0_c2`, `seafari_t0`.`body` AS `t0_c3`, `seafari_t0`.`id` AS `t0_c4`, `seafari_t0`.`left_id` AS `t0_c5`, `seafari_t0`.`right_id` AS `t0_c6`, `seafari_t0`.`tree_id` AS `t0_c7`, `seafari_t0`.`depth` AS `t0_c8`, `seafari_t0`.`color` AS `t0_c9`, `seafari_t0`.`parents` AS `t0_c10`, `seafari_t0`.`media_id` AS `t0_c11`, `seafari_t0`.`hash` AS `t0_c12`, `seafari_t0`.`uri` AS `t0_c13`, `seafari_t0`.`status` AS `t0_c14`, `seafari_t0`.`created_at` AS `t0_c15`, `seafari_t0`.`updated_at` AS `t0_c16`, `seafari_t0`.`layout` AS `t0_c17` FROM `seafari_pages` AS `seafari_t0` WHERE `seafari_t0`.`tree_id` = '1' AND `seafari_t0`.`left_id` < '1' AND `seafari_t0`.`right_id` > '118' ORDER BY `seafari_t0`.`right_id` ASC LIMIT 1Connection name: default Speed: 0.247 ms · DUPLICATE Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: left_id,right_id · Key Used: left_id · Type: range · Rows: 1 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model/nestedset.php, line 1623File: PKGPATH/orm/classes/model/nestedset.php, line 1368File: PKGPATH/orm/classes/model/nestedset.php, line 1523File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: PKGPATH/orm/classes/model/nestedset.php, line 1586File: PKGPATH/orm/classes/model/nestedset.php, line 1332File: /var/www/frameworks/fuelphp/proxapps/modules/pages/classes/controller/pages.php, line 168File: COREPATH/base.php, line 464File: COREPATH/classes/controller/hybrid.php, line 79File: COREPATH/classes/request.php, line 443File: DOCROOT/index.php, line 76File: DOCROOT/index.php, line 97 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`name` AS `t0_c1`, `seafari_t0`.`path` AS `t0_c2`, `seafari_t0`.`type` AS `t0_c3`, `seafari_t0`.`mimetype` AS `t0_c4`, `seafari_t0`.`extension` AS `t0_c5`, `seafari_t0`.`size` AS `t0_c6`, `seafari_t0`.`width` AS `t0_c7`, `seafari_t0`.`height` AS `t0_c8`, `seafari_t0`.`resizes` AS `t0_c9`, `seafari_t0`.`created_at` AS `t0_c10`, `seafari_t0`.`updated_at` AS `t0_c11` FROM `seafari_medias` AS `seafari_t0` WHERE `seafari_t0`.`id` = '862' LIMIT 1Connection name: default Speed: 0.319 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model/nestedset.php, line 1315File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/modules/pages/view.php, line 4File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`slug` AS `t0_c1`, `seafari_t0`.`title` AS `t0_c2`, `seafari_t0`.`grid` AS `t0_c3` FROM `seafari_widget_areas` AS `seafari_t0` WHERE `seafari_t0`.`id` = '1' LIMIT 1Connection name: default Speed: 0.304 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/modules/pages/view.php, line 188File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`module_folder` AS `t0_c1`, `seafari_t0`.`slug` AS `t0_c2`, `seafari_t0`.`title` AS `t0_c3`, `seafari_t0`.`description` AS `t0_c4`, `seafari_t0`.`icon` AS `t0_c5` FROM `seafari_widgets` AS `seafari_t0` WHERE `seafari_t0`.`id` = '15' LIMIT 1Connection name: default Speed: 0.220 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: id · Key Used: id · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/modules/pages/view.php, line 188File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`id_seadream` AS `t0_c1`, `seafari_t0`.`name` AS `t0_c2`, `seafari_t0`.`slug` AS `t0_c3` FROM `seafari_seabase_countries` AS `seafari_t0` WHERE `seafari_t0`.`id` = '1' LIMIT 1Connection name: default Speed: 0.308 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/modules/cruises/classes/controller/widgets/cruises.php, line 104File: COREPATH/base.php, line 461File: COREPATH/classes/controller/rest.php, line 152File: COREPATH/classes/request.php, line 443File: APPPATH/themes/seafari/modules/pages/view.php, line 215File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id_seadream` AS `t0_c0`, `seafari_t0`.`id_seabase` AS `t0_c1`, `seafari_t0`.`tour_id` AS `t0_c2`, `seafari_t0`.`boat_id` AS `t0_c3`, `seafari_t0`.`media_id` AS `t0_c4`, `seafari_t0`.`name` AS `t0_c5`, `seafari_t0`.`slug` AS `t0_c6`, `seafari_t0`.`description` AS `t0_c7`, `seafari_t0`.`seats` AS `t0_c8`, `seafari_t0`.`price` AS `t0_c9`, `seafari_t0`.`price_usd` AS `t0_c10`, `seafari_t0`.`special_price` AS `t0_c11`, `seafari_t0`.`special_price_usd` AS `t0_c12`, `seafari_t0`.`place_start` AS `t0_c13`, `seafari_t0`.`place_end` AS `t0_c14`, `seafari_t0`.`date_start` AS `t0_c15`, `seafari_t0`.`date_end` AS `t0_c16`, `seafari_t0`.`hash` AS `t0_c17`, `seafari_t0`.`created_at_seadream` AS `t0_c18`, `seafari_t0`.`updated_at_seadream` AS `t0_c19`, `seafari_t0`.`created_at` AS `t0_c20`, `seafari_t0`.`updated_at` AS `t0_c21`, `seafari_t0`.`price_gbp` AS `t0_c22`, `seafari_t0`.`special_price_gbp` AS `t0_c23`, `seafari_t0`.`price_chf` AS `t0_c24`, `seafari_t0`.`special_price_chf` AS `t0_c25`, `seafari_t0`.`price_cad` AS `t0_c26`, `seafari_t0`.`special_price_cad` AS `t0_c27`, `seafari_t0`.`price_ars` AS `t0_c28`, `seafari_t0`.`special_price_ars` AS `t0_c29`, `seafari_t0`.`price_brl` AS `t0_c30`, `seafari_t0`.`special_price_brl` AS `t0_c31`, `seafari_t0`.`price_sgd` AS `t0_c32`, `seafari_t0`.`special_price_sgd` AS `t0_c33`, `seafari_t0`.`price_idr` AS `t0_c34`, `seafari_t0`.`special_price_idr` AS `t0_c35`, `seafari_t0`.`price_aed` AS `t0_c36`, `seafari_t0`.`special_price_aed` AS `t0_c37`, `seafari_t0`.`price_cny` AS `t0_c38`, `seafari_t0`.`special_price_cny` AS `t0_c39`, `seafari_t0`.`price_krw` AS `t0_c40`, `seafari_t0`.`special_price_krw` AS `t0_c41`, `seafari_t0`.`price_jpy` AS `t0_c42`, `seafari_t0`.`special_price_jpy` AS `t0_c43`, `seafari_t0`.`price_rub` AS `t0_c44`, `seafari_t0`.`special_price_rub` AS `t0_c45`, `seafari_t0`.`country_id` AS `t0_c46` FROM `seafari_seabase_cruises` AS `seafari_t0` WHERE `seafari_t0`.`country_id` = '1' AND `seafari_t0`.`price` > 0 AND `seafari_t0`.`special_price` > 0 ORDER BY `seafari_t0`.`date_start` ASCConnection name: default Speed: 0.616 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: country_id · Key Used: country_id · Type: ref · Rows: 106 (Using index condition; Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: APPPATH/modules/cruises/classes/controller/widgets/cruises.php, line 113File: COREPATH/base.php, line 461File: COREPATH/classes/controller/rest.php, line 152File: COREPATH/classes/request.php, line 443File: APPPATH/themes/seafari/modules/pages/view.php, line 215File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`name` AS `t0_c1`, `seafari_t0`.`path` AS `t0_c2`, `seafari_t0`.`type` AS `t0_c3`, `seafari_t0`.`mimetype` AS `t0_c4`, `seafari_t0`.`extension` AS `t0_c5`, `seafari_t0`.`size` AS `t0_c6`, `seafari_t0`.`width` AS `t0_c7`, `seafari_t0`.`height` AS `t0_c8`, `seafari_t0`.`resizes` AS `t0_c9`, `seafari_t0`.`created_at` AS `t0_c10`, `seafari_t0`.`updated_at` AS `t0_c11` FROM `seafari_medias` AS `seafari_t0` WHERE `seafari_t0`.`id` = '37' LIMIT 1Connection name: default Speed: 0.260 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/partials/footer.php, line 24File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`name` AS `t0_c1`, `seafari_t0`.`path` AS `t0_c2`, `seafari_t0`.`type` AS `t0_c3`, `seafari_t0`.`mimetype` AS `t0_c4`, `seafari_t0`.`extension` AS `t0_c5`, `seafari_t0`.`size` AS `t0_c6`, `seafari_t0`.`width` AS `t0_c7`, `seafari_t0`.`height` AS `t0_c8`, `seafari_t0`.`resizes` AS `t0_c9`, `seafari_t0`.`created_at` AS `t0_c10`, `seafari_t0`.`updated_at` AS `t0_c11` FROM `seafari_medias` AS `seafari_t0` WHERE `seafari_t0`.`id` = '33' LIMIT 1Connection name: default Speed: 0.192 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/partials/footer.php, line 24File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`name` AS `t0_c1`, `seafari_t0`.`path` AS `t0_c2`, `seafari_t0`.`type` AS `t0_c3`, `seafari_t0`.`mimetype` AS `t0_c4`, `seafari_t0`.`extension` AS `t0_c5`, `seafari_t0`.`size` AS `t0_c6`, `seafari_t0`.`width` AS `t0_c7`, `seafari_t0`.`height` AS `t0_c8`, `seafari_t0`.`resizes` AS `t0_c9`, `seafari_t0`.`created_at` AS `t0_c10`, `seafari_t0`.`updated_at` AS `t0_c11` FROM `seafari_medias` AS `seafari_t0` WHERE `seafari_t0`.`id` = '36' LIMIT 1Connection name: default Speed: 0.141 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/partials/footer.php, line 24File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |
SELECT `seafari_t0`.`id` AS `t0_c0`, `seafari_t0`.`name` AS `t0_c1`, `seafari_t0`.`path` AS `t0_c2`, `seafari_t0`.`type` AS `t0_c3`, `seafari_t0`.`mimetype` AS `t0_c4`, `seafari_t0`.`extension` AS `t0_c5`, `seafari_t0`.`size` AS `t0_c6`, `seafari_t0`.`width` AS `t0_c7`, `seafari_t0`.`height` AS `t0_c8`, `seafari_t0`.`resizes` AS `t0_c9`, `seafari_t0`.`created_at` AS `t0_c10`, `seafari_t0`.`updated_at` AS `t0_c11` FROM `seafari_medias` AS `seafari_t0` WHERE `seafari_t0`.`id` = '34' LIMIT 1Connection name: default Speed: 0.139 ms Query analysis: · Query: SIMPLE on seafari_t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1293File: PKGPATH/orm/classes/query.php, line 1365File: PKGPATH/orm/classes/belongsto.php, line 72File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/themes/seafari/partials/footer.php, line 24File: COREPATH/classes/view.php, line 238File: COREPATH/classes/view.php, line 252File: COREPATH/classes/view.php, line 589File: COREPATH/classes/theme.php, line 383File: COREPATH/classes/theme.php, line 163File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 114 |