| 0.0013 |
SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'
|
| 0.0002 |
SET bytea_output=escape
|
| 0.0006 |
SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('delareyweg')
|
| 0.0004 |
SELECT id
, dealer_id
, street
, house_number
, zip_code
, country
, city
, latitude
, longitude
, deleted
, webshop_active
, webshop_slug
, webshop_marquee_text
, webshop_information
, webshop_store_hours
, webshop_ordering_allowed
, webshop_twitter
, webshop_facebook
, max_kilo_per_timezone
, max_orders_per_timezone
, email_address
, webshop_order_cc_email_address
, logo_path
, webshop_online_folder_path
, name
, webshop_resell_enabled
, webshop_resell_discount_percentage
, seo_text
, api_key
FROM delivery_addresses
WHERE id = '52' AND deleted = 'f'
|
| 0.0003 |
SELECT phone_number, sms, fax, for_webshop
FROM delivery_address_phone_numbers
WHERE delivery_address_id = '52'
|
| 0.0006 |
SELECT start_time, end_time, active, id
FROM delivery_address_time_zones
WHERE delivery_address_id = '52'
ORDER BY start_time ASC
|
| 0.0005 |
SELECT id
, name
, internal_name
, active
, remark
, debtor_number
, prepay
, automatic_reservations
, invoice_email_address
, invoice_address_street
, invoice_address_house_number
, invoice_address_zip_code
, invoice_address_country
, invoice_address_city
, price_list_id
, free_products
, free_products_cash_register
, product_set_id
, pin_enabled
, wants_newsletter
, has_price_control
, allow_minus_sales
, is_platinum
FROM dealers
WHERE deleted = false
AND id = '57'
ORDER BY name ASC
|
| 0.0006 |
SELECT id
, dealer_id
, street
, house_number
, zip_code
, country
, city
, latitude
, longitude
, deleted
, webshop_active
, webshop_slug
, webshop_marquee_text
, webshop_information
, webshop_store_hours
, webshop_ordering_allowed
, webshop_twitter
, webshop_facebook
, max_kilo_per_timezone
, max_orders_per_timezone
, email_address
, webshop_order_cc_email_address
, logo_path
, webshop_online_folder_path
, name
, webshop_resell_enabled
, webshop_resell_discount_percentage
, driving_time
, api_key
FROM delivery_addresses
WHERE '57' IS NULL OR dealer_id = '57' AND deleted = 'f'
ORDER BY city ASC
|
| 0.0003 |
SELECT phone_number, sms, fax, for_webshop
FROM delivery_address_phone_numbers
WHERE delivery_address_id = '52'
|
| 0.0008 |
SELECT start_time, end_time, active, id
FROM delivery_address_time_zones
WHERE delivery_address_id = '52'
ORDER BY start_time ASC
|
| 0.0004 |
SELECT id, image_path FROM dealer_webshop_slider_images WHERE dealer_id = '57'
|
| 0.0005 |
SELECT id
, name
, active
, invoice_email_address
, remark
, debtor_number
, prepay
, automatic_reservations
, invoice_address_street
, invoice_address_house_number
, invoice_address_zip_code
, invoice_address_country
, invoice_address_city
, deleted
, price_list_id
, free_products
, product_set_id
, wants_newsletter
, pin_enabled
, has_price_control
, free_products_cash_register
FROM dealers
WHERE id IN ('57')
|
| 0.0006 |
SELECT product_id, maximum FROM dealer_product_maximums WHERE dealer_id = '57'
|
| 0.0004 |
SELECT id FROM product_sets WHERE id = '1'
|
| 0.0006 |
SELECT product_id FROM product_set_products WHERE product_set_id = '1'
|
| 0.0003 |
SELECT id, image_path, product_id, description, sort_order
FROM product_set_slides
WHERE product_set_id = '1'
|
| 0.0008 |
SELECT p.id
, p.name, p.description
, p.brand_id, b.name AS brand_name
, p.active
, p.gross_weight_per_box, p.weight_per_article
, p.barcode_box, p.barcode_product, p.sku, p.article_number
, p.ce_number, p.ce_category, p.nem_per_box
, p.hazard_code_class_number, p.hazard_code_compatibility_group
, p.sales_price_per_article, p.sales_price_per_article_for_discount, p.power_price
, p.burn_time, p.effect_height
, p.articles_per_box, p.packed_by
, p.warehouse_location, p.warehouse_sublocation
, p.shots_per_cake, p.is_fan
, p.primary_image_id
, p.slug
, p.is_safety_product
, p.expose_in_api
, p.min_main_warehouse_stock
, p.cbm
, p.is_rocket
FROM products AS p
LEFT JOIN product_brands AS b
ON b.id = p.brand_id
WHERE p.id = '475'
|
| 0.0006 |
SELECT c.name, c.id, c.slug
FROM product_categories AS c
JOIN product_categorizations AS cz
ON cz.category_id = c.id
WHERE cz.product_id = '475'
|
| 0.0003 |
SELECT *
FROM product_assets
WHERE product_id = '475'
|
| 0.0003 |
SELECT ps.id,
ps.name,
ps.logo_path,
ps.slug,
ps.description
FROM product_brands ps
WHERE id = '18'
|
| 0.0007 |
SELECT p.id
, p.name, p.description
, p.brand_id, b.name AS brand_name
, p.active
, p.gross_weight_per_box, p.weight_per_article
, p.barcode_box, p.barcode_product, p.sku, p.article_number
, p.ce_number, p.ce_category, p.nem_per_box
, p.hazard_code_class_number, p.hazard_code_compatibility_group
, p.sales_price_per_article, p.sales_price_per_article_for_discount, p.power_price
, p.burn_time, p.effect_height
, p.articles_per_box, p.packed_by
, p.warehouse_location, p.warehouse_sublocation
, p.shots_per_cake, p.is_fan
, p.primary_image_id
, p.slug
, p.is_safety_product
, p.expose_in_api
, p.min_main_warehouse_stock
, p.cbm
, p.is_rocket
FROM products AS p
LEFT JOIN product_brands AS b
ON b.id = p.brand_id
WHERE p.id = '1178'
|
| 0.0005 |
SELECT c.name, c.id, c.slug
FROM product_categories AS c
JOIN product_categorizations AS cz
ON cz.category_id = c.id
WHERE cz.product_id = '1178'
|
| 0.0003 |
SELECT *
FROM product_assets
WHERE product_id = '1178'
|
| 0.0002 |
SELECT ps.id,
ps.name,
ps.logo_path,
ps.slug,
ps.description
FROM product_brands ps
WHERE id = '20'
|
| 0.0005 |
SELECT p.id
, p.name, p.description
, p.brand_id, b.name AS brand_name
, p.active
, p.gross_weight_per_box, p.weight_per_article
, p.barcode_box, p.barcode_product, p.sku, p.article_number
, p.ce_number, p.ce_category, p.nem_per_box
, p.hazard_code_class_number, p.hazard_code_compatibility_group
, p.sales_price_per_article, p.sales_price_per_article_for_discount, p.power_price
, p.burn_time, p.effect_height
, p.articles_per_box, p.packed_by
, p.warehouse_location, p.warehouse_sublocation
, p.shots_per_cake, p.is_fan
, p.primary_image_id
, p.slug
, p.is_safety_product
, p.expose_in_api
, p.min_main_warehouse_stock
, p.cbm
, p.is_rocket
FROM products AS p
LEFT JOIN product_brands AS b
ON b.id = p.brand_id
WHERE p.id = '476'
|
| 0.0004 |
SELECT c.name, c.id, c.slug
FROM product_categories AS c
JOIN product_categorizations AS cz
ON cz.category_id = c.id
WHERE cz.product_id = '476'
|
| 0.0003 |
SELECT *
FROM product_assets
WHERE product_id = '476'
|
| 0.0002 |
SELECT ps.id,
ps.name,
ps.logo_path,
ps.slug,
ps.description
FROM product_brands ps
WHERE id = '18'
|
| 0.0005 |
SELECT p.id
, p.name, p.description
, p.brand_id, b.name AS brand_name
, p.active
, p.gross_weight_per_box, p.weight_per_article
, p.barcode_box, p.barcode_product, p.sku, p.article_number
, p.ce_number, p.ce_category, p.nem_per_box
, p.hazard_code_class_number, p.hazard_code_compatibility_group
, p.sales_price_per_article, p.sales_price_per_article_for_discount, p.power_price
, p.burn_time, p.effect_height
, p.articles_per_box, p.packed_by
, p.warehouse_location, p.warehouse_sublocation
, p.shots_per_cake, p.is_fan
, p.primary_image_id
, p.slug
, p.is_safety_product
, p.expose_in_api
, p.min_main_warehouse_stock
, p.cbm
, p.is_rocket
FROM products AS p
LEFT JOIN product_brands AS b
ON b.id = p.brand_id
WHERE p.id = '1180'
|
| 0.0006 |
SELECT c.name, c.id, c.slug
FROM product_categories AS c
JOIN product_categorizations AS cz
ON cz.category_id = c.id
WHERE cz.product_id = '1180'
|
| 0.0003 |
SELECT *
FROM product_assets
WHERE product_id = '1180'
|
| 0.0003 |
SELECT ps.id,
ps.name,
ps.logo_path,
ps.slug,
ps.description
FROM product_brands ps
WHERE id = '20'
|
| 0.0015 |
SELECT product_id AS id
FROM dealer_product_exceptions
WHERE dealer_id = '57'
UNION
SELECT psp.product_id AS id
FROM product_set_products AS psp
WHERE psp.product_set_id = ( SELECT d.product_set_id
FROM dealers AS d
WHERE d.id = '57'
)
|
| 0.0022 |
SELECT p.*, b.name AS brand_name
FROM products AS p
LEFT JOIN product_brands AS b
ON b.id = p.brand_id
WHERE p.id IN (184, 477, 552, 146, 1075, 190, 162, 554, 170, 176, 169, 309, 180, 547, 1067, 197, 475, 689, 1167, 470, 482, 693, 227, 478, 173, 311, 329, 420, 257, 153, 147, 338, 1166, 703, 226, 1168, 687, 259, 691, 288, 310, 1070, 1165, 171, 366, 307, 165, 151, 1068, 1164, 305, 546, 686, 321, 681, 466, 1084, 174, 472, 144, 1071, 168, 163, 690, 223, 1058, 219, 175, 343, 467, 167, 312, 231, 340, 158, 460, 155, 487, 195, 459, 1076, 699, 207, 368, 488, 369, 1180, 194, 476, 367, 1073, 1178, 224, 355, 157, 1083, 413, 308, 1072, 150, 191, 159, 495, 1087, 154, 709, 316, 474, 177, 1074, 549, 1179, 185, 178, 1082, 145, 148)
ORDER BY p.name
|
| 0.0023 |
SELECT c.name, c.id, c.slug, cz.product_id
FROM product_categories AS c
JOIN product_categorizations AS cz
ON cz.category_id = c.id
WHERE cz.product_id IN (184, 477, 552, 146, 1075, 190, 162, 554, 170, 176, 169, 309, 180, 547, 1067, 197, 475, 689, 1167, 470, 482, 693, 227, 478, 173, 311, 329, 420, 257, 153, 147, 338, 1166, 703, 226, 1168, 687, 259, 691, 288, 310, 1070, 1165, 171, 366, 307, 165, 151, 1068, 1164, 305, 546, 686, 321, 681, 466, 1084, 174, 472, 144, 1071, 168, 163, 690, 223, 1058, 219, 175, 343, 467, 167, 312, 231, 340, 158, 460, 155, 487, 195, 459, 1076, 699, 207, 368, 488, 369, 1180, 194, 476, 367, 1073, 1178, 224, 355, 157, 1083, 413, 308, 1072, 150, 191, 159, 495, 1087, 154, 709, 316, 474, 177, 1074, 549, 1179, 185, 178, 1082, 145, 148)
|
| 0.0006 |
SELECT *
FROM product_brands
WHERE id IN (29, 20, 27, 17, 22, 18, 15, 14, 23, 32, 26, 33, 21)
|
| 0.0016 |
SELECT *
FROM product_assets
WHERE product_id IN (184, 477, 552, 146, 1075, 190, 162, 554, 170, 176, 169, 309, 180, 547, 1067, 197, 475, 689, 1167, 470, 482, 693, 227, 478, 173, 311, 329, 420, 257, 153, 147, 338, 1166, 703, 226, 1168, 687, 259, 691, 288, 310, 1070, 1165, 171, 366, 307, 165, 151, 1068, 1164, 305, 546, 686, 321, 681, 466, 1084, 174, 472, 144, 1071, 168, 163, 690, 223, 1058, 219, 175, 343, 467, 167, 312, 231, 340, 158, 460, 155, 487, 195, 459, 1076, 699, 207, 368, 488, 369, 1180, 194, 476, 367, 1073, 1178, 224, 355, 157, 1083, 413, 308, 1072, 150, 191, 159, 495, 1087, 154, 709, 316, 474, 177, 1074, 549, 1179, 185, 178, 1082, 145, 148)
|
| 0.0016 |
SELECT p.id,
( CASE
WHEN p.power_price
THEN coalesce( ( SELECT pp.price
FROM powerprices AS pp
WHERE pp.dealer_id = '57'
AND pp.product_id = p.id
)
, p.sales_price_per_article
)
ELSE p.sales_price_per_article
END
) AS price
FROM products AS p
WHERE p.id IN (184, 477, 552, 146, 1075, 190, 162, 554, 170, 176, 169, 309, 180, 547, 1067, 197, 475, 689, 1167, 470, 482, 693, 227, 478, 173, 311, 329, 420, 257, 153, 147, 338, 1166, 703, 226, 1168, 687, 259, 691, 288, 310, 1070, 1165, 171, 366, 307, 165, 151, 1068, 1164, 305, 546, 686, 321, 681, 466, 1084, 174, 472, 144, 1071, 168, 163, 690, 223, 1058, 219, 175, 343, 467, 167, 312, 231, 340, 158, 460, 155, 487, 195, 459, 1076, 699, 207, 368, 488, 369, 1180, 194, 476, 367, 1073, 1178, 224, 355, 157, 1083, 413, 308, 1072, 150, 191, 159, 495, 1087, 154, 709, 316, 474, 177, 1074, 549, 1179, 185, 178, 1082, 145, 148)
ORDER BY p.id
|
| 0.0030 |
SELECT
products.id,
products.name,
products.article_number,
alternative_products.original_product_article
FROM alternative_products
JOIN products on products.article_number = alternative_products.article_number
WHERE alternative_products.original_product_article IN (925, 923, 3427, 3432, 2688, 2505, 4050, 4045, 2620, 2067, 2066, 2014, 2071, 2025, 2479, 2480, 2618, 2027, 3425, 2054, 2050, 3421, 2060, 2215, 4080, 3442, 5042, 3423, 911, 3419, 2320, 2449, 598, 2323, 2324, 2993, 3415, 2362, 2991, 2206, 3417, 6205, 912, 5003, 6220, 3624, 2317, 2212, 2570, 2365, 2312, 2569, 932, 3500, 2517, 2516, 2231, 2222, 2208, 3447, 2319, 2305, 2016, 2980, 2310, 2367, 3535, 2221, 3431, 2511, 6240, 2315, 2680, 2684, 2670, 935, 922, 2249, 2999, 3480, 6230, 3409, 2985, 2954, 2960, 2550, 2360, 6130, 2998, 2518, 6212, 2540, 2543, 2545, 3460, 2220, 2075, 2004, 2330, 2325, 2329, 3402, 3404, 3405, 3401, 3445, 2512, 6211, 3420, 2022, 2370, 3436, 931, 910, 3490, 3470, 2560)
AND alternative_products.article_number IN (925, 923, 3427, 3432, 2688, 2505, 4050, 4045, 2620, 2067, 2066, 2014, 2071, 2025, 2479, 2480, 2618, 2027, 3425, 2054, 2050, 3421, 2060, 2215, 4080, 3442, 5042, 3423, 911, 3419, 2320, 2449, 598, 2323, 2324, 2993, 3415, 2362, 2991, 2206, 3417, 6205, 912, 5003, 6220, 3624, 2317, 2212, 2570, 2365, 2312, 2569, 932, 3500, 2517, 2516, 2231, 2222, 2208, 3447, 2319, 2305, 2016, 2980, 2310, 2367, 3535, 2221, 3431, 2511, 6240, 2315, 2680, 2684, 2670, 935, 922, 2249, 2999, 3480, 6230, 3409, 2985, 2954, 2960, 2550, 2360, 6130, 2998, 2518, 6212, 2540, 2543, 2545, 3460, 2220, 2075, 2004, 2330, 2325, 2329, 3402, 3404, 3405, 3401, 3445, 2512, 6211, 3420, 2022, 2370, 3436, 931, 910, 3490, 3470, 2560)
|
| 0.0005 |
SELECT id, parent_id, name, image_path, active, slug
FROM product_categories
WHERE active = 't'
|
| 0.0003 |
SELECT condition FROM admin_settings
WHERE name = 'overview_check_stocks'
|
| 0.0006 |
SELECT product_id
FROM delivery_address_manual_out_of_stock_products
WHERE delivery_address_id = '52'
AND product_id IN (158, 478, 459, 1067, 355, 470, 703, 185, 184, 475, 145, 195, 476, 691, 477, 338, 482, 552, 472, 547, 153, 151, 460, 690, 699, 1180)
|
| 0.0005 |
SELECT product_id
FROM delivery_address_manual_out_of_stock_products
WHERE delivery_address_id = '52'
AND product_id = '690'
|
| 0.0005 |
SELECT id
, dealer_id
, street
, house_number
, zip_code
, country
, city
, latitude
, longitude
, deleted
, webshop_active
, webshop_slug
, webshop_marquee_text
, webshop_information
, webshop_store_hours
, webshop_ordering_allowed
, max_kilo_per_timezone
, max_orders_per_timezone
, email_address
, webshop_order_cc_email_address
, webshop_twitter
, webshop_facebook
, name
, logo_path
, webshop_resell_enabled
, webshop_resell_discount_percentage
, driving_time
FROM delivery_addresses
WHERE id IN ('52')
|
| 0.0005 |
SELECT product_id
FROM delivery_address_local_stock_sales_only_products
WHERE delivery_address_id = '52'
|
| 0.0003 |
SELECT dealer_id
FROM delivery_addresses
WHERE id = '52'
|
| 0.0004 |
SELECT get_articles_per_box(690) as amount
|
| 0.0064 |
SELECT delivery_address_free_articles(690, '52', '57') as free
|
| 0.0062 |
SELECT delivery_address_free_articles(690, '52', '57') as free
|
| 0.0033 |
SELECT cafferata_free_articles(690) as free
|
| 0.0005 |
SELECT product_id
FROM delivery_address_manual_out_of_stock_products
WHERE delivery_address_id = '52'
AND product_id = '1167'
|
| 0.0004 |
SELECT product_id
FROM delivery_address_local_stock_sales_only_products
WHERE delivery_address_id = '52'
|
| 0.0003 |
SELECT dealer_id
FROM delivery_addresses
WHERE id = '52'
|
| 0.0003 |
SELECT get_articles_per_box(1167) as amount
|
| 0.0059 |
SELECT delivery_address_free_articles(1167, '52', '57') as free
|
| 0.0060 |
SELECT delivery_address_free_articles(1167, '52', '57') as free
|
| 0.0040 |
SELECT cafferata_free_articles(1167) as free
|
| 0.0006 |
SELECT is_platinum
FROM dealers
WHERE id = '57'
|
