| 0.0003 |
SELECT GET_LOCK('mc6ghglucgb32brq5j3osaal6oioqrvv', 300) AS ci_session_lock
|
| 0.0003 |
SELECT `data`
FROM `ci_sessions`
WHERE `id` = 'mc6ghglucgb32brq5j3osaal6oioqrvv'
|
| 0.0008 |
SELECT *
FROM `inu_settings`
|
| 0.0003 |
SELECT *
FROM `inu_file`
WHERE `file_category` = 'site_og'
ORDER BY `file_order` asc, `file_regdate` asc, `file_order` asc, `file_orig_name` asc
|
| 0.0005 |
SELECT *
FROM `inu_goods`
WHERE `gds_code` = 'HUDGD-7142'
|
| 0.0005 |
SELECT *, sum(goval_stock) as sum_goval_stock
FROM `inu_goods`
LEFT JOIN `inu_goods_selected_category` ON `gscat_gds_idx`=`gds_idx`
LEFT JOIN `inu_goods_category` ON `gscat_gcat_idx`=`gcat_idx`
LEFT JOIN `inu_goods_option_value` ON `gds_idx` = `goval_gds_idx`
WHERE `gds_idx` = 35
GROUP BY `gds_idx`
|
| 0.0004 |
SELECT *
FROM `inu_file`
WHERE `file_category` LIKE '%gds%' ESCAPE '!'
AND `file_foreign_idx` = '35'
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0003 |
SELECT *
FROM `inu_file`
WHERE `file_foreign_idx` = '35'
AND `file_category` LIKE '%gds!_list%' ESCAPE '!'
ORDER BY `file_order` asc, `file_regdate` asc
|
| 0.0005 |
SHOW COLUMNS FROM `inu_goods`
|
| 0.0029 |
UPDATE `inu_goods` SET gds_count = gds_count+1
WHERE `gds_idx` = '35'
|
| 0.0003 |
SELECT *
FROM `inu_goods_selected_category`
WHERE `gscat_gds_idx` = '35'
ORDER BY `gscat_order`
|
| 0.0001 |
SELECT *
FROM `inu_goods_category`
WHERE `gcat_idx` = '18'
|
| 0.0002 |
SELECT *
FROM `inu_goods_selected_category`
LEFT JOIN `inu_goods_category` ON `gscat_gcat_idx`=`gcat_idx`
WHERE `gcat_tree` LIKE '%|18|%' ESCAPE '!'
|
| 0.0002 |
SELECT *
FROM `inu_goods_category`
WHERE `gcat_idx` = '2'
|
| 0.0003 |
SELECT COUNT(*) AS `numrows`
FROM `inu_goods_reviews`
LEFT JOIN `inu_member` ON `gdrw_mem_idx`=`mem_idx`
LEFT JOIN `inu_order_goods` ON `gdrw_ordg_idx`=`ordg_idx`
LEFT JOIN `inu_order` ON `ordg_ord_idx`=`ord_idx`
LEFT JOIN `inu_reviews_best` ON `rwbt_gdrw_idx`=`gdrw_idx`
WHERE `gdrw_status` = 1 AND `gdrw_depth` =0 AND `rwbt_gdrw_idx` IS NOT NULL AND `gdrw_gds_idx` = 35
|
| 0.0009 |
SELECT *
FROM `inu_goods_reviews`
LEFT JOIN `inu_member` ON `gdrw_mem_idx`=`mem_idx`
LEFT JOIN `inu_order_goods` ON `gdrw_ordg_idx`=`ordg_idx`
LEFT JOIN `inu_order` ON `ordg_ord_idx`=`ord_idx`
LEFT JOIN `inu_reviews_best` ON `rwbt_gdrw_idx`=`gdrw_idx`
WHERE `gdrw_status` = 1 AND `gdrw_depth` =0 AND `rwbt_gdrw_idx` IS NOT NULL AND `gdrw_gds_idx` = 35
ORDER BY `rwbt_order`, `rwbt_idx` ASC
LIMIT 5
|
| 0.0002 |
SELECT COUNT(*) AS `numrows`
FROM `inu_goods_reviews`
WHERE `gdrw_gds_idx` = '35'
|
| 0.0002 |
SELECT *
FROM `inu_member_group`
|
| 0.0002 |
SELECT *
FROM `inu_point`
WHERE `pt_foreign_idx` =0
AND `pt_category` = 'point'
AND `pt_type` IN('review_text', 'review_photo')
ORDER BY `pt_foreign_idx` DESC
|
| 0.0009 |
SELECT COUNT(*) AS `numrows`
FROM (
SELECT *, sum(goval_stock) as sum_goval_stock
FROM `inu_goods`
LEFT JOIN `inu_goods_relation` ON `gds_idx`=`gr_relation_idx`
LEFT JOIN `inu_goods_selected_category` ON `gscat_gds_idx`=`gds_idx`
LEFT JOIN `inu_goods_category` ON `gscat_gcat_idx`=`gcat_idx`
LEFT JOIN `inu_goods_option_value` ON `gds_idx` = `goval_gds_idx`
WHERE `gr_gds_idx` = 35 AND `gds_status` = 1
GROUP BY `gds_idx`
) CI_count_all_results
|
| 0.0008 |
SELECT *, sum(goval_stock) as sum_goval_stock
FROM `inu_goods`
LEFT JOIN `inu_goods_relation` ON `gds_idx`=`gr_relation_idx`
LEFT JOIN `inu_goods_selected_category` ON `gscat_gds_idx`=`gds_idx`
LEFT JOIN `inu_goods_category` ON `gscat_gcat_idx`=`gcat_idx`
LEFT JOIN `inu_goods_option_value` ON `gds_idx` = `goval_gds_idx`
WHERE `gr_gds_idx` = 35 AND `gds_status` = 1
GROUP BY `gds_idx`
ORDER BY `gr_order` ASC
LIMIT 99
|
| 0.0003 |
SELECT *
FROM `inu_goods_page_sections`
WHERE `gpsec_gds_idx` = '35'
AND `gpsec_status` = 1
ORDER BY `gpsec_order` ASC
|
| 0.0038 |
SELECT *
FROM `inu_recent_view`
WHERE `rv_session_id` = 'mc6ghglucgb32brq5j3osaal6oioqrvv'
AND `rv_gds_idx` = 'HUDGD-7142'
|
| 0.0023 |
INSERT INTO `inu_recent_view` (`rv_gds_idx`, `rv_session_id`, `rv_regdate`) VALUES ('HUDGD-7142', 'mc6ghglucgb32brq5j3osaal6oioqrvv', '2024-12-26 21:37:55')
|
| 0.0003 |
SELECT *
FROM `inu_page`
WHERE `page_group` = 'ko'
AND `page_menu_status` = 1
ORDER BY `page_order`
|
| 0.0002 |
SELECT MAX(`gcat_depth`) AS `gcat_depth`
FROM `inu_goods_category`
|
| 0.0002 |
SELECT `t1`.`gcat_idx` as `t1_gcat_idx`, `t2`.`gcat_idx` as `t2_gcat_idx`, `t3`.`gcat_idx` as `t3_gcat_idx`, `t4`.`gcat_idx` as `t4_gcat_idx`, `t1`.`gcat_title` as `t1_gcat_title`, `t2`.`gcat_title` as `t2_gcat_title`, `t3`.`gcat_title` as `t3_gcat_title`, `t4`.`gcat_title` as `t4_gcat_title`, `t1`.`gcat_depth` as `t1_gcat_depth`, `t2`.`gcat_depth` as `t2_gcat_depth`, `t3`.`gcat_depth` as `t3_gcat_depth`, `t4`.`gcat_depth` as `t4_gcat_depth`
FROM `inu_goods_category` as `t1`
LEFT JOIN `inu_goods_category` as `t2` ON `t2`.`gcat_parent` = `t1`.`gcat_idx`
LEFT JOIN `inu_goods_category` as `t3` ON `t3`.`gcat_parent` = `t2`.`gcat_idx`
LEFT JOIN `inu_goods_category` as `t4` ON `t4`.`gcat_parent` = `t3`.`gcat_idx`
WHERE `t1`.`gcat_parent` =0
ORDER BY `t1`.`gcat_order` ASC, `t2`.`gcat_order` ASC, `t3`.`gcat_order` ASC, `t4`.`gcat_order` ASC
|
| 0.0002 |
SELECT *
FROM `inu_goods_category`
WHERE `gcat_idx` = '2'
|
| 0.0002 |
SELECT *
FROM `inu_page`
WHERE `page_group` = 'ko' AND `page_type` = 7 AND (`page_gcat_link` = '' OR `page_gcat_link` like '%|2|%')
ORDER BY `page_gcat_link` DESC
|
