| 0.0001 |
SELECT *
FROM `currencies`
ORDER BY `id` ASC
|
| 0.0001 |
SELECT *
FROM `users2currencies`
|
| 0.0003 |
SELECT `s`.*, `cc`.*
FROM `shops` `s`
LEFT JOIN `c_content` `cc` ON `cc`.`id`=`s`.`id`
WHERE `s`.`id` = 2006
|
| 0.0001 |
SELECT `file_name`, `media_type`
FROM `media`
WHERE `shop_id` = '2006'
AND (`media_type` = "logo" OR `media_type` = "favicon")
AND `active` = 1
|
| 0.0001 |
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` = '1080'
|
| 0.0001 |
SELECT *
FROM `sub_cms`
WHERE `shop_id` = '2006'
AND `type` = 'cms'
AND `active` = 1
ORDER BY `index` ASC, `date` DESC
|
| 0.0000 |
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` = '1080'
GROUP BY `s`.`id`
|
| 0.0031 |
SELECT
p.id, p.shop_id, p.name, p.short_name, p.description, p.product_tax, p.type, p.var1, p.var2, p.var3, p.oos_hide_except, p.show_in_upsell, p.variant, p.sold_count AS sold,
p.url, p.category_oos_order_last, p.category_new_products_order_first, p.category_indent, p.base_product_show_number, p.show_trigger, p.base_product, p.category_sort_by,
p.product_index, p.dropshop_product_id, p.feature_on_homepage, p.variant_auto_configurator, p.default_category,
p2s.pair_price, p2s.pair_discount, p2s.pair_quantity_discount,
IF(pp.primary_id IS NOT NULL, 'primary', IF(pp2.primary_id IS NOT NULL, 'secondary', NULL)) AS pos,
IF(pp.primary_id IS NOT NULL, pp.primary_id, IF(pp2.primary_id IS NOT NULL, pp2.primary_id, NULL)) AS primary_id,
IF(pp.own_id IS NOT NULL, pp.own_id, IF(pp2.own_id IS NOT NULL, pp2.own_id, NULL)) AS own_id,
IF(pp.import_code IS NOT NULL, pp.import_code, IF(pp2.import_code IS NOT NULL, pp2.import_code, NULL)) AS import_code,
IF(pp.marked IS NOT NULL, pp.marked, IF(pp2.marked IS NOT NULL, pp2.marked, NULL)) AS marked,
IF(pp.supplier_id IS NOT NULL, pp.supplier_id, IF(pp2.supplier_id IS NOT NULL, pp2.supplier_id, NULL)) AS supplier_id,
IF(pp.primary_id IS NOT NULL, pp.sold_count, IF(pp2.primary_id IS NOT NULL, pp2.sold_count, NULL)) AS primary_sold,
IF(p.ean IS NOT NULL, p.ean, IF(pp.barcode IS NULL, IF(pp2.barcode IS NULL, NULL, pp2.barcode), pp.barcode)) AS barcode,
IF(p.manufacturer IS NOT NULL, p.manufacturer, IF(pp.primary_manufacturer IS NULL, IF(pp2.primary_manufacturer IS NULL, NULL, pp2.primary_manufacturer), pp.primary_manufacturer)) AS manufacturer,
IF(pp.length IS NULL, IF(pp2.length IS NULL, NULL, pp2.length), pp.length) AS length,
IF(pp.width IS NULL, IF(pp2.width IS NULL, NULL, pp2.width), pp.width) AS width,
IF(pp.height IS NULL, IF(pp2.height IS NULL, NULL, pp2.height), pp.height) AS height,
IF(pp.weight IS NULL, IF(pp2.weight IS NULL, 0, pp2.weight), pp.weight) AS weight,
IF(pp.quantity IS NOT NULL, pp.quantity, IF(pp2.quantity IS NOT NULL, pp2.quantity, p.quantity)) AS quantity,
IF(pp.thumbnail IS NOT NULL AND LENGTH(pp.thumbnail) > 0, pp.thumbnail, IF(pp2.thumbnail IS NOT NULL AND p2s.pair_picture=1 AND LENGTH(pp2.thumbnail) > 0, pp2.thumbnail, p.thumbnail)) AS thumbnail,
IF(pp.yt_video IS NULL, IF(pp2.yt_video IS NULL, NULL, pp2.yt_video), pp.yt_video) AS yt_video,
IF(pp.price IS NOT NULL AND pp.price > 0, pp.price, IF(pp2.price IS NOT NULL AND p2s.pair_price=1, IF(p2s.pair_condition=1,pp2.price,pp2.price_original),p.price)) AS price,
IF(pp.price_original IS NOT NULL AND pp.price_original > 0, pp.price_original, IF(pp2.price_original IS NOT NULL AND p2s.pair_price=1, pp2.price_original, p.price)) AS price_original,
IF(pp.price_modifier IS NOT NULL, pp.price_modifier, IF(pp2.price_modifier IS NOT NULL, pp2.price_modifier, NULL)) AS price_modifier,
IF(pp.price_modifier_fake IS NOT NULL, pp.price_modifier_fake, IF(pp2.price_modifier_fake IS NOT NULL, pp2.price_modifier_fake, NULL)) AS price_modifier_fake,
IF(pp.discount_like IS NOT NULL AND pp.discount_like = 1 AND pp.price_modifier < 0, pp.discount_like, IF(pp2.discount_like IS NOT NULL AND p2s.pair_discount = 1 AND pp2.discount_like = 1 AND pp2.price_modifier < 0 AND p2s.pair_price = 1 AND p2s.pair_condition = 1, pp2.discount_like, NULL)) AS discount_like,
IF(pp.increase_quantity_value_here IS NOT NULL, pp.increase_quantity_value_here, pp2.increase_quantity_value_here) AS increase_quantity_value_here,
IF(pp.quantity_on_road IS NOT NULL, pp.quantity_on_road, pp2.quantity_on_road) AS quantity_on_road,
IF(pp.primary_set IS NOT NULL, pp.primary_set, pp2.primary_set) AS primary_set,
IF(pp.solo_order IS NOT NULL, pp.solo_order, pp2.solo_order) AS solo_order,
ABS(TIMESTAMPDIFF(MINUTE, IF(pp2.primary_id IS NOT NULL AND p2.creation_date NOT LIKE '0000-00-00 00:00:00', p2.creation_date, p.creation_date), NOW())) AS product_minutes_old
FROM product p
LEFT JOIN primary_product pp ON p.id = pp.primary_id
LEFT JOIN primary2secondary p2s ON p2s.secondary_id = p.id
LEFT JOIN primary_product pp2 ON p2s.primary_id = pp2.primary_id
LEFT JOIN product p2 ON p2s.primary_id = p2.id
WHERE
p.active = 1
AND p.shop_id = 2006
AND (pp.status = 1 OR pp.status IS NULL)
AND (pp2.status = 1 OR pp2.status IS NULL)
GROUP BY p.id
ORDER BY p.product_index ASC
|
| 0.0001 |
SELECT `id`
FROM `product`
WHERE `shop_id` = '2006'
AND (`active` = 1 OR `active` = 2)
|
| 0.0000 |
SELECT `file_name`
FROM `media`
WHERE `shop_id` = '2006'
AND `active` = 1
AND `media_type` = 'gallery'
ORDER BY `media_index`
|
| 0.0000 |
SELECT `file_name`, `sub1`, `sub2`, `link`
FROM `media`
WHERE `shop_id` = '2006'
AND `active` = 1
AND `media_type` = 'slider'
ORDER BY `media_index`
|
| 0.0000 |
SELECT *
FROM `scripts`
WHERE `shop_id` = '2006'
AND `script_active` = 1
|
| 0.0000 |
SELECT *
FROM `shipping`
WHERE `shop_id` = '2006'
AND `active` = 1
AND `visible` = 0
ORDER BY `shipping_index`
|
| 0.0000 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `shop_id` = '2006'
AND `active` = 1
ORDER BY `position`
|
| 0.0000 |
SELECT *
FROM `sub_cms`
WHERE `shop_id` = '2006'
AND `type` = 'blog'
AND `active` = 1
ORDER BY `index` ASC, `date` DESC
|
| 0.0000 |
SELECT *
FROM `primary_quantity_discount_cached`
WHERE `shop_id` = '2006'
ORDER BY `quantity`
|
| 0.0056 |
SELECT
IF(pv.product_id IS NULL, op.product_id, pv.product_id) AS pid,
COUNT(op.quantity) AS pocet
FROM orders o
JOIN orders_products op ON o.id = op.order_id
JOIN product p ON p.id = op.product_id
LEFT JOIN product_variant pv ON pv.primary_id = op.primary_id AND pv.shop_id = 2006
WHERE
o.shop_id = 2006
AND o.date >= '2019-01-20 21:13:24'
AND o.order_active=1
AND (p.active OR pv.product_id IS NOT NULL)
GROUP BY IF(pv.product_id IS NULL, op.product_id, pv.product_id)
ORDER BY pocet DESC LIMIT 100
|
| 0.0001 |
(SELECT shop1 AS id,s.name,s.url,s.country,s.ssl FROM shop2shop LEFT JOIN shops s ON s.id=shop1 WHERE shop2='2006') UNION
(SELECT shop2 AS id,s.name,s.url,s.country,s.ssl FROM shop2shop LEFT JOIN shops s ON s.id=shop2 WHERE shop1='2006')
|
| 0.0040 |
SELECT
a.name, a.city,
o.date, o.order_currency, o.shop_id,
IF(pv.product_id IS NULL, op.product_id, pv.product_id) AS pid,
COUNT(op.product_id) AS quantity, op.price, op.name AS product_name,
IF(pp.thumbnail IS NULL OR pp.thumbnail LIKE '', p.thumbnail, pp.thumbnail) AS thumbnail
FROM orders o
JOIN orders_products op ON o.id = op.order_id
JOIN address a ON a.id = o.address_id
LEFT JOIN primary_product pp ON pp.primary_id = op.primary_id
JOIN product p ON p.id = op.product_id
LEFT JOIN product_variant pv ON pv.primary_id = op.primary_id
WHERE
o.shop_id IN (2006)
AND o.date > '2019-02-15 17:13:24'
AND o.order_active = 1
AND op.quantity > 0
GROUP BY op.order_id
ORDER BY o.date DESC
LIMIT 100
|
| 0.0001 |
SELECT *
FROM `user_invoice_settings`
WHERE `user_id` = '1080'
AND `invoice_address_id` = '432970'
AND `status` = 1
AND `country` = 'cs'
|
| 0.0002 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = 2027
|
| 0.0072 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `parent_id` = 2027
AND `active` = 1
ORDER BY `position`
|
| 0.0006 |
SELECT `f`.`id`, IFNULL(f2co.name, f.name) AS 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` = 2027
ORDER BY `fv`.`index`
|
| 0.0002 |
SELECT `p2c`.`product_id`
FROM `product2category` `p2c`
JOIN `product` `p` ON `p`.`id` = `p2c`.`product_id`
WHERE `p2c`.`category_id` = 2027
ORDER BY `p`.`sold_count` DESC
|
| 0.0001 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '2027'
|
| 0.0001 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '2019'
|
| 0.0000 |
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_name
FROM `category`
WHERE `id` = '1999'
|
| 0.0001 |
SELECT *
FROM `media`
WHERE `shop_id` = '2006'
AND `media_type` = 'sticky_floating_banner'
AND `active` = 1
|
| 0.0000 |
SELECT *
FROM `media`
WHERE `shop_id` = '2006'
AND `media_type` = 'cart_button_icon'
AND `active` = 1
|
