Orchid Garden | Prestige Hampers

Copyright © 2025 Prestige Hampers™

Page generated in 0.2427 seconds.
Memory Usage: 7.16 MB
We have executed 39 queries.

Array
(
    [0] => Array
        (
            [0] => SELECT  * FROM uri_mappings um WHERE  um.uri = 'summer-plants/orchid-garden'  AND um.current = 'Yes'  AND um.content_type = 'Category'  ORDER BY um.content_id DESC 
            [1] => 0.0040459632873535
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #159 
        )

    [1] => Array
        (
            [0] => SELECT  * FROM uri_mappings um LEFT JOIN products p on um.content_id = p.id WHERE  um.uri = 'summer-plants/orchid-garden'  AND um.current = 'Yes'  AND um.content_type = 'Product'  AND p.status = 'Enabled'  ORDER BY um.content_id DESC 
            [1] => 0.0041530132293701
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #159 
        )

    [2] => Array
        (
            [0] => SELECT  * FROM uri_mappings um WHERE  um.uri = 'summer-plants/orchid-garden'  AND um.current = 'Yes'  AND um.content_type = 'Static Page'  ORDER BY um.content_id DESC 
            [1] => 0.003943920135498
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #159 
        )

    [3] => Array
        (
            [0] => SELECT  *, p.id AS products_id, pd.id AS description_id, p.sku FROM products p LEFT JOIN products_descriptions pd on p.id=pd.products_id WHERE  p.id IN ( '11831' )  AND p.status = 'Enabled'  ORDER BY FIELD (p.id, "11831") ASC 
            [1] => 0.0065510272979736
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #65 
        )

    [4] => Array
        (
            [0] => 	SELECT uri, content_id 
											FROM uri_mappings
											WHERE content_type='Product'
											AND current='Yes'
											AND content_id IN(null,11831)
										
            [1] => 0.0044360160827637
            [2] => DB->Query() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #36 
        )

    [5] => Array
        (
            [0] => 	SELECT pi.location, pi.alt_text, pi.size_image, pi.overhead, pti.product_id
											FROM products_to_images pti, products_images pi
											WHERE pti.image_id=pi.id
											AND pti.enabled='Yes'
											AND pti.product_id IN(null,11831)
											ORDER BY pti.sort ASC
										
            [1] => 0.0048279762268066
            [2] => DB->Query() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1114 
        )

    [6] => Array
        (
            [0] => 	SELECT p2c.products_id, p2c.categories_id, p2c.sort, c.name, um.uri
										FROM products_to_categories p2c, categories c, uri_mappings um
										WHERE c.id=p2c.categories_id
											AND c.id=um.content_id
											AND c.enabled='Yes'
											AND um.content_type='Category'
											AND um.current='Yes'
											AND p2c.products_id IN(null,11831)
											ORDER BY p2c.sort ASC
											LIMIT '25'
										
            [1] => 0.009620189666748
            [2] => DB->Query() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #898 
        )

    [7] => Array
        (
            [0] => SELECT  	f2p.feature_id, f2p.product_id, f2p.content, 
																			uf.id AS the_feature_id, uf.feature_name FROM feature_to_product f2p LEFT JOIN unique_features uf on uf.id=f2p.feature_id WHERE  f2p.product_id IN ( '11831' )  ORDER BY uf.sort ASC 
            [1] => 0.00048303604125977
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #944 
        )

    [8] => Array
        (
            [0] => SELECT  s2p.feature_id, s2p.product_id, s2p.content, 
																				sf.id AS the_feature_id, sf.feature_name FROM substitution_to_product s2p LEFT JOIN substitution_features sf on sf.id=s2p.feature_id WHERE  s2p.product_id IN ( '11831' )  ORDER BY sf.sort ASC 
            [1] => 0.00041699409484863
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1033 
        )

    [9] => Array
        (
            [0] => SELECT  d2p.feature_id, d2p.product_id, d2p.content, 
																			df.id AS the_feature_id, df.feature_name FROM delivery_to_product d2p LEFT JOIN delivery_features df on df.id=d2p.feature_id WHERE  d2p.product_id IN ( '11831' )  ORDER BY df.sort ASC 
            [1] => 0.00041604042053223
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #988 
        )

    [10] => Array
        (
            [0] => SELECT  * FROM products_meta WHERE  products_id IN ( '11831' ) 
            [1] => 0.00092601776123047
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1075 
        )

    [11] => Array
        (
            [0] => SELECT  * FROM meta_data WHERE  content_id IN ( '11831' )  AND content_type = 'Product'  AND site_id IN ( '0', '8' )  ORDER BY id DESC 
            [1] => 0.00052595138549805
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_pages.php" line #102 
        )

    [12] => Array
        (
            [0] => SELECT  keywords, products_id FROM products_meta WHERE  products_id IN ( '11831' ) 
            [1] => 0.00078701972961426
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1204 
        )

    [13] => Array
        (
            [0] => SELECT  * FROM products_sizes ps LEFT JOIN products_images pi on (pi.id = ps.image_id AND pi.size_image = "Yes") WHERE  ps.products_id IN ( '11831' )  ORDER BY ps.price ASC 
            [1] => 0.0028238296508789
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #2787 
        )

    [14] => Array
        (
            [0] => SELECT  * FROM information_schema.tables WHERE  table_schema = 'prestigeflowers'  AND table_name in ( 'product_allergens' )  LIMIT 1
            [1] => 0.00067996978759766
            [2] => DB->tableExists() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #547 
        )

    [15] => Array
        (
            [0] => SELECT  * FROM information_schema.tables WHERE  table_schema = 'prestigeflowers'  AND table_name in ( 'products_to_allergens' )  LIMIT 1
            [1] => 0.00063681602478027
            [2] => DB->tableExists() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #547 
        )

    [16] => Array
        (
            [0] => SELECT  pa.id, pa.name, p2a.products_id FROM products_to_allergens p2a LEFT JOIN product_allergens pa on pa.id=p2a.allergens_id WHERE  p2a.products_id IN ( '11831' ) 
            [1] => 0.00046086311340332
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #551 
        )

    [17] => Array
        (
            [0] => SELECT  * FROM information_schema.tables WHERE  table_schema = 'prestigeflowers'  AND table_name in ( 'countries' )  LIMIT 1
            [1] => 0.00062918663024902
            [2] => DB->tableExists() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #514 
        )

    [18] => Array
        (
            [0] => SELECT  * FROM countries
            [1] => 0.00084590911865234
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #516 
        )

    [19] => Array
        (
            [0] => SELECT  p2c.products_id, p2c.countries_id, c.name FROM products_to_countries p2c LEFT JOIN countries c on c.id=p2c.countries_id WHERE  p2c.products_id IN ( '11831' ) 
            [1] => 0.00041508674621582
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #361 
        )

    [20] => Array
        (
            [0] => SELECT  id, sku, distributor, delivery_method, country_code FROM products WHERE  id IN ( '11831' ) 
            [1] => 0.00039505958557129
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #378 
        )

    [21] => Array
        (
            [0] => SELECT  * FROM products_special_discounts WHERE  discounted_product_id IN ( '11831' )  AND start_date <= '2025-02-11 18:20:29'  AND end_date >= '2025-02-11 18:20:29' 
            [1] => 0.00043416023254395
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #3083 
        )

    [22] => Array
        (
            [0] => SELECT  dd.disabled_date FROM disabled_dates dd WHERE  dd.is_global = 'Yes' 
            [1] => 0.00066995620727539
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1787 
        )

    [23] => Array
        (
            [0] => SELECT  dd.disabled_date FROM disabled_dates dd LEFT JOIN disabled_dates_to_delivery_method dd2dm on dd.id=dd2dm.date_id WHERE  dd.is_global = 'No'  AND dd2dm.delivery_method = '47' 
            [1] => 0.0004429817199707
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1787 
        )

    [24] => Array
        (
            [0] => SELECT  dd.disabled_date FROM disabled_dates dd LEFT JOIN disabled_dates_distributors ddd on dd.id=ddd.disabled_date_id WHERE  dd.is_global = 'No'  AND ddd.distributor = 'julian' 
            [1] => 0.00095915794372559
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1787 
        )

    [25] => Array
        (
            [0] => SELECT  * FROM addon_occasions
            [1] => 0.00036001205444336
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #3150 
        )

    [26] => Array
        (
            [0] => SELECT  * FROM addons_products WHERE  addons_product = '11831'  LIMIT 1
            [1] => 0.0004119873046875
            [2] => DB->getOne() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1864 
        )

    [27] => Array
        (
            [0] => SELECT  * FROM addons_delivery_method adm LEFT JOIN addons_group ag on ag.addons_group=adm.addons_group WHERE  adm.delivery_method = '47'  LIMIT 1
            [1] => 0.00044703483581543
            [2] => DB->getOne() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #2314 
        )

    [28] => Array
        (
            [0] => SELECT  * FROM addons WHERE  distributor = 'julian'  AND enabled = '1'  ORDER BY FIELD (id, "1007","1008","1034","1026","20","1049","1044","1043","1048","6","8","68","1018","58","13","14","61","") ASC 
            [1] => 0.0012071132659912
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #2340 
        )

    [29] => Array
        (
            [0] => SELECT  * FROM information_schema.tables WHERE  table_schema = 'prestigeflowers'  AND table_name in ( 'addons_bundles_items' )  LIMIT 1
            [1] => 0.00059795379638672
            [2] => DB->tableExists() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #2229 
        )

    [30] => Array
        (
            [0] => SELECT * FROM addons_featured
            [1] => 0.00094890594482422
            [2] => DB->Query() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #2261 
        )

    [31] => Array
        (
            [0] => SELECT  * FROM website_banners WHERE  active_from < NOW() AND active_until > NOW() AND enabled = 'Yes'  AND site_id IN ( '0', '8' )  ORDER BY priority ASC, id DESC 
            [1] => 0.00065708160400391
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_templates.php" line #288 
        )

    [32] => Array
        (
            [0] => SELECT  * FROM information_schema.tables WHERE  table_schema = 'prestigeflowers'  AND table_name in ( 'navigation_categories', 'navigation_links' )  LIMIT 2
            [1] => 0.00077915191650391
            [2] => DB->tableExists() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #200 
        )

    [33] => Array
        (
            [0] => SELECT  c.category_name as cat_name, c.category_slug as cat_slug, c.category_img as cat_img, c.classes as cat_classes, l.link_name, l.link_slug, l.classes as link_class, c.order as cat_order, l.order as link_order, l.peaks as link_peak, c.peaks as cat_peak, c.site_id as cat_site, l.site_id as link_site, um.content_id as category_id FROM navigation_links l LEFT JOIN navigation_categories c on l.submenu_id = c.id LEFT JOIN uri_mappings um on ((um.uri = (CASE WHEN SUBSTRING(l.link_slug, 1, 1) = '/' THEN SUBSTRING(l.link_slug, 2) ELSE l.link_slug END)) AND um.content_type = 'Category' AND um.current = 'Yes') WHERE  l.enabled = '1'  AND (c.enabled = '1' OR c.enabled is null) AND l.site_id IN ( '0', '8' )  GROUP BY l.id  ORDER BY c.order ASC, l.order ASC 
            [1] => 0.0086519718170166
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_urimapping.php" line #213 
        )

    [34] => Array
        (
            [0] => SELECT  pxs.product_id, pxs.related_product_id, pxs.sort, pxs.global FROM products_cross_sell pxs  JOIN products p on p.id=pxs.related_product_id WHERE  pxs.product_id IN ( '11831' )  AND p.stock >= '1'  AND p.status = 'Enabled'  ORDER BY pxs.sort ASC  LIMIT 3
            [1] => 0.00048303604125977
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1269 
        )

    [35] => Array
        (
            [0] => SELECT  pxs.product_id, pxs.related_product_id, pxs.sort, pxs.global FROM products_cross_sell pxs  JOIN products p on p.id=pxs.related_product_id WHERE  pxs.global = 'Yes'  AND p.stock >= '1'  AND p.status = 'Enabled'  ORDER BY pxs.sort ASC  LIMIT 3
            [1] => 0.00042986869812012
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1279 
        )

    [36] => Array
        (
            [0] => SELECT  pxs.product_id, pxs.related_product_id, pxs.sort, pxs.global FROM products_cross_sell pxs  JOIN products p on p.id=pxs.related_product_id WHERE  pxs.product_id IN ( '11831' )  AND p.stock >= '1'  AND p.status = 'Enabled'  ORDER BY pxs.sort ASC  LIMIT 3
            [1] => 0.00045180320739746
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1269 
        )

    [37] => Array
        (
            [0] => SELECT  pxs.product_id, pxs.related_product_id, pxs.sort, pxs.global FROM products_cross_sell pxs  JOIN products p on p.id=pxs.related_product_id WHERE  pxs.global = 'Yes'  AND p.stock >= '1'  AND p.status = 'Enabled'  ORDER BY pxs.sort ASC  LIMIT 3
            [1] => 0.00044488906860352
            [2] => DB->get() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_products.php" line #1279 
        )

    [38] => Array
        (
            [0] => SELECT  * FROM website_ouibounce WHERE  enabled = 'Yes'  AND site_id IN ( '0', '8' )  ORDER BY id DESC  LIMIT 1
            [1] => 0.00048398971557617
            [2] => DB->getOne() >>  file "/HD1/vhosts/core_ac168e3904fed6b8482a8e5e493045c96909f63a/includes/class_templates.php" line #350 
        )

)