SELECT challenge.id, comprank.count
FROM challenge
INNER JOIN (
SELECT * , count( id ) AS count
FROM completion
GROUP BY challenge_id
ORDER BY count DESC
)comprank ON challenge.id = comprank.challenge_id
LIMIT 0 , 30Connection name: default Speed: 7.317 ms Query analysis: · Query: PRIMARY on <derived2> · Type: ALL · Rows: 22 · Query: PRIMARY on challenge · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using index) · Query: DERIVED on completion · Type: ALL · Rows: 22 (Using temporary; Using filesort) Call trace for this query:File: APPPATH/classes/model/challenge.php, line 184File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '714') LIMIT 1Connection name: default Speed: 0.474 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '713') LIMIT 1Connection name: default Speed: 0.494 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '2') LIMIT 1Connection name: default Speed: 0.364 ms Query analysis: · Query: SIMPLE (Impossible WHERE noticed after reading const tables) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '698') LIMIT 1Connection name: default Speed: 0.349 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '8') LIMIT 1Connection name: default Speed: 0.782 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '699') LIMIT 1Connection name: default Speed: 0.389 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '752') LIMIT 1Connection name: default Speed: 0.402 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '10') LIMIT 1Connection name: default Speed: 0.384 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '702') LIMIT 1Connection name: default Speed: 0.658 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '765') LIMIT 1Connection name: default Speed: 3.281 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '12') LIMIT 1Connection name: default Speed: 1.065 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '703') LIMIT 1Connection name: default Speed: 0.577 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '761') LIMIT 1Connection name: default Speed: 1.002 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '469') LIMIT 1Connection name: default Speed: 0.693 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '704') LIMIT 1Connection name: default Speed: 1.024 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '777') LIMIT 1Connection name: default Speed: 1.002 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '695') LIMIT 1Connection name: default Speed: 0.620 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '705') LIMIT 1Connection name: default Speed: 0.359 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '696') LIMIT 1Connection name: default Speed: 0.496 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '706') LIMIT 1Connection name: default Speed: 0.563 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '697') LIMIT 1Connection name: default Speed: 0.780 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`name` AS `t0_c1`, `t0`.`desc` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`medal_type` AS `t0_c4`, `t0`.`points` AS `t0_c5`, `t0`.`region_id` AS `t0_c6`, `t0`.`ts_created` AS `t0_c7`, `t0`.`ts_deleted` AS `t0_c8` FROM `challenge` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`id` = '711') LIMIT 1Connection name: default Speed: 0.785 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/model.php, line 608File: APPPATH/classes/model/challenge.php, line 192File: APPPATH/classes/controller/challenge.php, line 56File: COREPATH/classes/request.php, line 454File: DOCROOT/index.php, line 71File: DOCROOT/index.php, line 92 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 714) LIMIT 1Connection name: default Speed: 0.348 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 714) LIMIT 1Connection name: default Speed: 0.970 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 714Connection name: default Speed: 3.539 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 713) LIMIT 1Connection name: default Speed: 0.789 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 713Connection name: default Speed: 0.891 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 698) LIMIT 1Connection name: default Speed: 0.535 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 698Connection name: default Speed: 0.836 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 8) LIMIT 1Connection name: default Speed: 0.414 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 8Connection name: default Speed: 1.164 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 699) LIMIT 1Connection name: default Speed: 0.359 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 699) LIMIT 1Connection name: default Speed: 0.687 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 699Connection name: default Speed: 2.110 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 752) LIMIT 1Connection name: default Speed: 0.515 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 752Connection name: default Speed: 0.981 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 10) LIMIT 1Connection name: default Speed: 0.529 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 10Connection name: default Speed: 0.872 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 702) LIMIT 1Connection name: default Speed: 0.500 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 702Connection name: default Speed: 0.823 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 765) LIMIT 1Connection name: default Speed: 0.324 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 765) LIMIT 1Connection name: default Speed: 0.556 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 765Connection name: default Speed: 0.920 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 12) LIMIT 1Connection name: default Speed: 0.407 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 12Connection name: default Speed: 0.833 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 703) LIMIT 1Connection name: default Speed: 0.503 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 703Connection name: default Speed: 2.083 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 761) LIMIT 1Connection name: default Speed: 0.574 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 761Connection name: default Speed: 0.868 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 469) LIMIT 1Connection name: default Speed: 0.569 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 469Connection name: default Speed: 0.916 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 704) LIMIT 1Connection name: default Speed: 0.432 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 704) LIMIT 1Connection name: default Speed: 0.801 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 704Connection name: default Speed: 1.097 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 777) LIMIT 1Connection name: default Speed: 0.587 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 777Connection name: default Speed: 0.963 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 695) LIMIT 1Connection name: default Speed: 0.536 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 695Connection name: default Speed: 0.902 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 705) LIMIT 1Connection name: default Speed: 0.484 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 705) LIMIT 1Connection name: default Speed: 0.514 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 705Connection name: default Speed: 1.131 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 696) LIMIT 1Connection name: default Speed: 0.524 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 696Connection name: default Speed: 0.971 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `multi` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 706) LIMIT 1Connection name: default Speed: 0.473 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 36 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 706) LIMIT 1Connection name: default Speed: 1.375 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 141File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 706Connection name: default Speed: 0.961 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 697) LIMIT 1Connection name: default Speed: 0.530 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 697Connection name: default Speed: 1.971 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`ts_created` AS `t0_c2`, `t0`.`ts_deleted` AS `t0_c3` FROM `single` AS `t0` WHERE `t0`.`ts_deleted` IS null AND (`t0`.`challenge_id` = 711) LIMIT 1Connection name: default Speed: 0.540 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 682 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/query/soft.php, line 49File: PKGPATH/orm/classes/query.php, line 1381File: PKGPATH/orm/classes/hasone.php, line 69File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/classes/model/challenge.php, line 138File: APPPATH/classes/model/challenge.php, line 171File: APPPATH/views/presenter/challenge/listcombine.php, line 15File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`challenge_id` AS `t0_c1`, `t0`.`tag` AS `t0_c2`, `t0`.`ts_create` AS `t0_c3` FROM `tag` AS `t0` WHERE `t0`.`challenge_id` = 711Connection name: default Speed: 0.911 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 1403 (Using where) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1304File: PKGPATH/orm/classes/hasmany.php, line 79File: PKGPATH/orm/classes/model.php, line 1144File: PKGPATH/orm/classes/model.php, line 980File: APPPATH/views/presenter/challenge/listcombine.php, line 23File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/presenter.php, line 326File: COREPATH/classes/presenter.php, line 343File: APPPATH/views/challenge/list.php, line 28File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: APPPATH/views/my.php, line 464File: COREPATH/classes/view.php, line 244File: COREPATH/classes/view.php, line 260File: COREPATH/classes/view.php, line 665File: COREPATH/classes/view.php, line 213File: COREPATH/classes/response.php, line 382File: DOCROOT/index.php, line 114 |