| 0.0004 |
SELECT *
FROM `currencies`
ORDER BY `id` ASC
|
| 0.0003 |
SELECT *
FROM `users2currencies`
|
| 0.0014 |
SELECT `s`.*, `cc`.*
FROM `shops` `s`
LEFT JOIN `c_content` `cc` ON `cc`.`id`=`s`.`id`
WHERE `s`.`id` = 7281
|
| 0.0005 |
SELECT `file_name`, `media_type`
FROM `media`
WHERE `shop_id` = '7281'
AND (`media_type` = "logo" OR `media_type` = "favicon")
AND `active` = 1
|
| 0.0003 |
SELECT `u`.`id`, `u`.`block_status`, `u`.`banned`, `u`.`block_emails`, `u`.`block_ips`, `u`.`ultra_block_emails`, `u`.`ultra_block_ips`, `u`.`block_amounts`, `u`.`hash`, `u`.`email`, `up`.`address_id`, `up`.`business_form`, `up`.`tax_sk`, `up`.`tax_hu`, `up`.`tax_de`, `up`.`language`, `up`.`vs_type`, `up`.`vs_prefix`, `up`.`owlcure`, `up`.`order_mail`, `a`.`name`, `a`.`phone` AS `owner_phone`
FROM `users` `u`
LEFT JOIN `user_profiles` `up` ON `up`.`user_id`=`u`.`id`
LEFT JOIN `address` `a` ON `a`.`id`=`up`.`address_id`
WHERE `u`.`id` = '691'
|
| 0.0007 |
SELECT *
FROM `sub_cms`
WHERE `shop_id` = '7281'
AND `type` = 'cms'
AND `active` = 1
ORDER BY `index` ASC, `date` DESC
|
| 0.0004 |
SELECT `s`.*, `ssf`.`stock_format`, `ssf`.`stock_format_info_text`, `ssf`.`stock_format_fake`, `ssf`.`stock_format_fake_info_text`
FROM `supplier` `s`
LEFT JOIN `supplier_stock_format` `ssf` ON `ssf`.`supplier_id` = `s`.`id` AND `ssf`.`country` = 'cs'
WHERE `s`.`user_id` IN('691')
GROUP BY `s`.`id`
|
| 0.0007 |
SELECT `file_name`
FROM `media`
WHERE `shop_id` = '7281'
AND `active` = 1
AND `media_type` = 'gallery'
ORDER BY `media_index`
|
| 0.0003 |
SELECT `file_name`, `sub1`, `sub2`, `link`
FROM `media`
WHERE `shop_id` = '7281'
AND `active` = 1
AND `media_type` = 'slider'
ORDER BY `media_index`
|
| 0.0003 |
SELECT *
FROM `scripts`
WHERE `shop_id` = '7281'
AND `script_active` = 1
|
| 0.0003 |
SELECT *
FROM `shipping`
WHERE `shop_id` = '7281'
AND `active` = 1
AND `visible` = 0
ORDER BY `shipping_index`
|
| 0.0306 |
SELECT *
FROM `branch_czech_post`
WHERE `type` = 'napostu'
ORDER BY `obec` ASC, `psc` ASC
|
| 0.0128 |
SELECT *
FROM `branch_czech_post`
WHERE `type` = 'napostu'
ORDER BY `obec` ASC, `psc` ASC
|
| 0.0049 |
SELECT *
FROM `branch_czech_post`
WHERE `type` = 'balikovna'
ORDER BY `obec` ASC, `psc` ASC
|
| 0.0030 |
SELECT *
FROM `branch_czech_post`
WHERE `type` = 'balikovna'
ORDER BY `obec` ASC, `psc` ASC
|
| 0.0040 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `shop_id` = '7281'
AND `active` = 1
ORDER BY `position`
|
| 0.0013 |
SELECT *
FROM `sub_cms`
WHERE `shop_id` = '7281'
AND `type` = 'blog'
AND `active` = 1
ORDER BY `index` ASC, `date` DESC
|
| 0.0004 |
SELECT *
FROM `primary_quantity_discount_cached`
WHERE `shop_id` = '7281'
ORDER BY `quantity`
|
| 0.0003 |
SELECT *
FROM `user_invoice_settings`
WHERE `user_id` = '691'
AND `invoice_address_id` = '836495'
AND `status` = 1
AND `country` = 'cs'
|
| 0.0002 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = 19671
|
| 0.0003 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `parent_id` = 19671
AND `active` = 1
ORDER BY `position`
|
| 0.0021 |
SELECT `f`.`id`, IFNULL(f2co.name, f.name) AS name, `f`.`name` AS `internal_name`, `fv`.`id` AS `value_id`, `fv`.`index` as `value_index`, IFNULL(fv2c.value, fv.value) AS value
FROM `feature2category` `f2c`
LEFT JOIN `feature` `f` ON `f`.`id` = `f2c`.`feature_id`
LEFT JOIN `feature_value` `fv` ON `fv`.`feature_id` = `f2c`.`feature_id`
LEFT JOIN `feature2country` `f2co` ON `f2co`.`feature_id` = `f2c`.`feature_id` AND `f2co`.`country` = 'cs'
LEFT JOIN `feature_value2country` `fv2c` ON `fv2c`.`feature_value_id` = `fv`.`id` AND `fv2c`.`country` = 'cs'
WHERE `f2c`.`category_id` = 19671
ORDER BY `fv`.`index`
|
| 0.0010 |
SELECT `f`.`id`
FROM `feature2category` `f2c`
JOIN `feature` `f` ON `f`.`id` = `f2c`.`feature_id`
WHERE `f2c`.`category_id` = 19671
ORDER BY `f`.`index` ASC
|
| 0.0003 |
SELECT `p2c`.`product_id`
FROM `product2category` `p2c`
JOIN `product` `p` ON `p`.`id` = `p2c`.`product_id`
WHERE `p2c`.`category_id` = 19671
ORDER BY `p`.`product_index` ASC
|
| 0.0010 |
SELECT `p2fv`.*, `f`.`auto_configurator_type`, `f`.`user_id`, `f`.`name` AS `internal_name`, `m`.`file_name` AS `value_image`, `fv`.`value` AS `internal_value_name`, `fv`.`product_label_id`, IFNULL(f2c.name, f.name) AS name, IFNULL(fv2c.value, fv.value) AS value
FROM `primary2feature_value` `p2fv`
JOIN `feature` `f` ON `f`.`id` = `p2fv`.`feature_id`
JOIN `feature_value` `fv` ON `fv`.`id` = `p2fv`.`feature_value_id`
LEFT JOIN `media` `m` ON `fv`.`id` = `m`.`feature_value_id` AND `m`.`active`=1 AND `m`.`media_type`="feature_value"
LEFT JOIN `feature2country` `f2c` ON `f`.`id` = `f2c`.`feature_id` AND `f2c`.`country` = 'cs'
LEFT JOIN `feature_value2country` `fv2c` ON `fv`.`id` = `fv2c`.`feature_value_id` AND `fv2c`.`country` = 'cs'
WHERE p2fv.primary_id IN(1031998, 3001254, 3001262, 3254699, 1254072, 1254076, 1255676)
AND `f`.`show_filtering` = 1
ORDER BY `f`.`name` ASC, `fv`.`index` ASC
|
| 0.0002 |
SELECT IF(pl2c.name IS NULL, `pl`.`name`, pl2c.name) AS name, `pl`.`color`, `pl`.`background_color`, `pl`.`bold`, `pl`.`id`
FROM `product_label` `pl`
LEFT JOIN `product_label2country` `pl2c` ON `pl2c`.`product_label_id` = `pl`.`id` AND `pl2c`.`country`='cs'
WHERE `pl`.`user_id` = '691'
AND `pl`.`active` = 1
|
| 0.0002 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '19671'
|
| 0.0002 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '19655'
|
| 0.0002 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '19649'
|
| 0.0001 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '7077'
|
| 0.0002 |
INSERT INTO visitors_online (time, shop_id, session) VALUES ('2020-01-29 21:00:19', 7281, '3.229.142.175')
ON DUPLICATE KEY UPDATE time='2020-01-29 21:00:19'
|
| 0.0001 |
INSERT INTO visitors (people, date, hour, shop_id) VALUES (1, '2020-01-29', '21', 7281)
ON DUPLICATE KEY UPDATE people=people+1
|
| 0.0003 |
SELECT *
FROM `media`
WHERE `shop_id` = '7281'
AND `media_type` = 'sticky_floating_banner'
AND `active` = 1
|
| 0.0002 |
SELECT *
FROM `media`
WHERE `shop_id` = '7281'
AND `media_type` = 'cart_button_icon'
AND `active` = 1
|
.png)
.jpg)
