| 0.0007 |
INSERT INTO `core_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('a256be2a7e08341f3adc5bd59b0e6722', '3.236.207.90', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1679501781, '')
|
| 0.0008 |
DESCRIBE `core_settings`
|
| 0.0004 |
SELECT *
FROM (`core_settings`)
ORDER BY `core_settings`.`module` ASC, `core_settings`.`order` ASC
|
| 0.0003 |
SHOW TABLES FROM `r81214mela_delifresh_en`
|
| 0.0007 |
DESCRIBE `core_routes`
|
| 0.0003 |
DESCRIBE `core_routes`
|
| 0.0001 |
SELECT *
FROM (`core_routes`)
|
| 0.0002 |
INSERT INTO `core_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('c476bca1bcd1ea6abbfce0510d44a9f6', '3.236.207.90', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1679501781, '')
|
| 0.0002 |
SELECT *
FROM (`core_settings`)
WHERE `core_settings`.`id` = 61
ORDER BY `core_settings`.`order` asc
LIMIT 1
|
| 0.0001 |
UPDATE `core_settings` SET `value` = '1679501781', `options` = '18632' WHERE `id` = 61
|
| 0.0006 |
DESCRIBE `core_users_resources`
|
| 0.0002 |
SELECT *
FROM (`core_users_resources`)
WHERE `core_users_resources`.`module` = 'catalog'
AND `core_users_resources`.`controller` = 'catalog'
AND `core_users_resources`.`method` = 'product'
ORDER BY `core_users_resources`.`module`, `core_users_resources`.`controller`
|
| 0.0002 |
SELECT *
FROM (`core_users_resources`)
WHERE CONCAT(`module`, '/', `controller`, '/', `method`) = 'catalog/catalog/product'
ORDER BY `core_users_resources`.`module`, `core_users_resources`.`controller`
LIMIT 1
|
| 0.0009 |
DESCRIBE `site_pages`
|
| 0.0004 |
DESCRIBE `site_pages`
|
| 0.0002 |
SELECT *
FROM (`site_pages`)
WHERE `site_pages`.`status` = 1
AND `site_pages`.`id` != 6
ORDER BY `site_pages`.`order` ASC
|
| 0.0004 |
DESCRIBE `core_routes_seo`
|
| 0.0004 |
DESCRIBE `core_routes_seo`
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'page'
AND `core_routes_seo`.`rel_id` IN (5, 1, 2, 3, 4)
|
| 0.0002 |
SELECT *
FROM (`site_pages`)
WHERE `site_pages`.`id` IN (5, 1, 2, 3, 4)
|
| 0.0006 |
DESCRIBE `site_catalog_categories`
|
| 0.0003 |
DESCRIBE `site_catalog_categories`
|
| 0.0002 |
SELECT *
FROM (`site_catalog_categories`)
WHERE `site_catalog_categories`.`status` = 1
ORDER BY `site_catalog_categories`.`order` ASC
|
| 0.0003 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'category'
AND `core_routes_seo`.`rel_id` IN (1, 3, 8, 9, 10, 11, 13, 14, 15, 16, 2, 4, 5, 6, 7)
|
| 0.0002 |
SELECT *
FROM (`site_catalog_categories`)
WHERE `site_catalog_categories`.`id` IN (1, 3, 8, 9, 10, 11, 13, 14, 15, 16, 2, 4, 5, 6, 7)
|
| 0.0007 |
DESCRIBE `site_catalog_products`
|
| 0.0004 |
DESCRIBE `site_catalog_products`
|
| 0.0003 |
SELECT `site_catalog_products`.`category_id`, count('id') AS prod_nr
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
GROUP BY `site_catalog_products`.`category_id`
|
| 0.0002 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
AND `site_catalog_products`.`id` = '6'
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0006 |
SELECT `site_catalog_products`.*, `site_catalog_products_specs`.`value`, `site_catalog_specs`.`title` AS spec_title
FROM (`site_catalog_products`)
LEFT JOIN `site_catalog_products_specs` ON `site_catalog_products`.`id` = `site_catalog_products_specs`.`product_id`
LEFT JOIN `site_catalog_specs` ON `site_catalog_products_specs`.`spec_id` = `site_catalog_specs`.`id`
WHERE `site_catalog_products`.`id` = '6'
|
| 0.0006 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
AND `site_catalog_products`.`category_id` = '6'
ORDER BY RAND()+2
LIMIT 4
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (7)
|
| 0.0001 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (7)
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0002 |
SELECT `site_catalog_products`.*, `site_catalog_products_specs`.`value`, `site_catalog_specs`.`title` AS spec_title
FROM (`site_catalog_products`)
LEFT JOIN `site_catalog_products_specs` ON `site_catalog_products`.`id` = `site_catalog_products_specs`.`product_id`
LEFT JOIN `site_catalog_specs` ON `site_catalog_products_specs`.`spec_id` = `site_catalog_specs`.`id`
WHERE `site_catalog_products`.`id` = 7
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (11)
|
| 0.0002 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (11)
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0003 |
SELECT `site_catalog_products`.*, `site_catalog_products_specs`.`value`, `site_catalog_specs`.`title` AS spec_title
FROM (`site_catalog_products`)
LEFT JOIN `site_catalog_products_specs` ON `site_catalog_products`.`id` = `site_catalog_products_specs`.`product_id`
LEFT JOIN `site_catalog_specs` ON `site_catalog_products_specs`.`spec_id` = `site_catalog_specs`.`id`
WHERE `site_catalog_products`.`id` = 11
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (12)
|
| 0.0001 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (12)
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0003 |
SELECT `site_catalog_products`.*, `site_catalog_products_specs`.`value`, `site_catalog_specs`.`title` AS spec_title
FROM (`site_catalog_products`)
LEFT JOIN `site_catalog_products_specs` ON `site_catalog_products`.`id` = `site_catalog_products_specs`.`product_id`
LEFT JOIN `site_catalog_specs` ON `site_catalog_products_specs`.`spec_id` = `site_catalog_specs`.`id`
WHERE `site_catalog_products`.`id` = 12
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (3)
|
| 0.0001 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (3)
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0002 |
SELECT `site_catalog_products`.*, `site_catalog_products_specs`.`value`, `site_catalog_specs`.`title` AS spec_title
FROM (`site_catalog_products`)
LEFT JOIN `site_catalog_products_specs` ON `site_catalog_products`.`id` = `site_catalog_products_specs`.`product_id`
LEFT JOIN `site_catalog_specs` ON `site_catalog_products_specs`.`spec_id` = `site_catalog_specs`.`id`
WHERE `site_catalog_products`.`id` = 3
|
| 0.0002 |
UPDATE `site_catalog_products` SET `views` = 1053, `updated` = '2023-03-22 16:16:21' WHERE `id` = 6
|
| 0.0002 |
SELECT `site_catalog_categories`.*
FROM (`site_catalog_categories`)
LEFT OUTER JOIN `site_catalog_products` site_catalog_products ON `site_catalog_categories`.`id` = `site_catalog_products`.`category_id`
WHERE `site_catalog_products`.`id` = 6
|
| 0.0006 |
DESCRIBE `core_users_users_history`
|
| 0.0005 |
ALTER TABLE `core_users_users_history` CHANGE `user_id` `user_id` INT NOT NULL
|
| 0.0004 |
ALTER TABLE `core_users_users_history` CHANGE `product_id` `product_id` INT NOT NULL
|
| 0.0004 |
ALTER TABLE `core_users_users_history` CHANGE `category_id` `category_id` INT NOT NULL
|
| 0.0004 |
ALTER TABLE `core_users_users_history` CHANGE `displayed` `displayed` INT NOT NULL DEFAULT '1'
|
| 0.0004 |
DESCRIBE `core_users_users_history`
|
| 0.0002 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (6)
|
| 0.0002 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (6)
ORDER BY `site_catalog_products`.`order` ASC
|
| 0.0004 |
DESCRIBE `site_catalog_products_specs`
|
| 0.0003 |
DESCRIBE `site_catalog_products_specs`
|
| 0.0004 |
DESCRIBE `site_catalog_specs`
|
| 0.0003 |
DESCRIBE `site_catalog_specs`
|
| 0.0003 |
SELECT `site_catalog_products_specs`.*, `site_catalog_specs`.`title` AS spec_title, `site_catalog_specs`.`group` AS spec_group, `site_catalog_specs`.`slug` AS spec_slug
FROM (`site_catalog_products_specs`)
LEFT OUTER JOIN `site_catalog_specs` site_catalog_specs ON `site_catalog_specs`.`id` = `site_catalog_products_specs`.`spec_id`
WHERE (
`site_catalog_products_specs`.`spec_id` IN (1, 2, 3, 4)
)
AND `site_catalog_products_specs`.`product_id` = 6
ORDER BY FIELD(site_catalog_products_specs.spec_id, 1, 2, 3, 4) ASC
|
| 0.0005 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
AND `site_catalog_products`.`id` IN ('54', '24', '50')
ORDER BY RAND()
LIMIT 3
|
| 0.0005 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
AND `site_catalog_products`.`id` IN ('54', '52', '23')
ORDER BY RAND()
LIMIT 3
|
| 0.0006 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`status` = 1
AND `site_catalog_products`.`id` != 6
AND `site_catalog_products`.`category_id` = '6'
ORDER BY RAND()
LIMIT 12
|
| 0.0005 |
SELECT *
FROM (`core_routes_seo`)
WHERE `core_routes_seo`.`rel_to` = 'product'
AND `core_routes_seo`.`rel_id` IN (50, 24, 54, 52, 23, 8, 5, 14, 13, 9, 10, 2, 4)
|
| 0.0003 |
SELECT *
FROM (`site_catalog_products`)
WHERE `site_catalog_products`.`id` IN (50, 24, 54, 52, 23, 8, 5, 14, 13, 9, 10, 2, 4)
ORDER BY `site_catalog_products`.`order` ASC
|
