| 0.0007 |
SELECT 1 FROM `ci_sessions` WHERE `id` = 'begsel343knq4lbdl9cf8mksimr7prgl'
|
| 0.0002 |
SELECT GET_LOCK('20564b2e28be4e8e725ca75d3fe1362f', 300) AS ci_session_lock
|
| 0.0006 |
SELECT `data` FROM `ci_sessions` WHERE `id` = 'begsel343knq4lbdl9cf8mksimr7prgl'
|
| 0.0006 |
SELECT id, name, area, site_name, start, end
FROM hall
WHERE rand_id = 'k8V63vfn'
AND deleted IS NULL
|
| 0.0003 |
SELECT id, name, area, site_name, start, end
FROM hall
WHERE rand_id = 'k8V63vfn'
AND deleted IS NULL
|
| 0.0007 |
SELECT t1.name, t1.img, t1.address, t1.tel, t1.icon_id, t2.img AS icon_img, t2.name AS icon_name
FROM store t1
LEFT JOIN icon t2 ON t1.icon_id = t2.id
WHERE t1.hall_id = '2'
AND t1.display = 1
AND t1.deleted IS NULL
|
| 0.0006 |
SELECT
t3.date,
t2.img,
t1.store_name,
t1.quantity,
t1.start,
t1.end
FROM
submit AS t1
JOIN
icon AS t2 ON t1.icon_id = t2.id
JOIN
schedule AS t3 ON t1.skd_id = t3.id
WHERE
t1.hall_id = '2'
AND t1.display = 1
AND t1.deleted IS NULL
AND t3.date >= CURDATE()
AND t3.display = 1
AND t3.deleted IS NULL
ORDER BY
t3.date ASC, t1.start ASC
|
| 0.0004 |
SELECT date, max, max_quantity, id
FROM schedule WHERE hall_id = '2'
AND display = 1
AND deleted IS NULL
AND date > CURDATE()
ORDER BY date ASC
|
| 0.0004 |
SELECT
t3.date,
COUNT(t1.id) AS submit_count
FROM
submit AS t1
JOIN
schedule AS t3 ON t1.skd_id = t3.id
WHERE
t1.hall_id = '2'
AND t1.display = 1
AND t1.deleted IS NULL
AND t3.date > CURDATE()
AND t3.display = 1
AND t3.deleted IS NULL
GROUP BY
t3.date
|