1 . SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'product_prices.html' 0.0007 sec
↳product_prices.php : 13 -> require_once
2 . SELECT section_id, status FROM admin_section WHERE section_id IN (SELECT section_id FROM admin_section_description where site_language_id = '1' AND LOWER(section_heading) = LOWER('Templates')) 0.0003 sec
↳product_prices.php : 13 -> require_once
3 . SELECT configuration_master.constant_name,configuration_master.set_value,configuration_master.default_value,configuration_master.setting_type FROM configuration_master ORDER BY configuration_master.sort_order ASC, configuration_master.configuration_id ASC 0.0006 sec
↳product_prices.php : 13 -> require_once
4 . SELECT SQL_CALC_FOUND_ROWS theme_general_cofiguration FROM site_theme WHERE theme_dir_name = 'abcimaging' 0.0002 sec
↳product_prices.php : 13 -> require_once
5 . SELECT payment_method_id FROM payment_method WHERE directory= 'payon_account' ORDER BY sort_order ASC 0.0002 sec
↳product_prices.php : 13 -> require_once
6 . SELECT * FROM external_services WHERE status = '1' 0.0002 sec
↳product_prices.php : 13 -> require_once
7 . SELECT * FROM website_logos WHERE corporate_id = 0 0.0002 sec
↳product_prices.php : 13 -> require_once
8 . SELECT * FROM site_language WHERE default_language = '1' 0.0003 sec
↳product_prices.php : 13 -> require_once
9 . SELECT * FROM site_currency WHERE default_currency = '1' 0.0002 sec
↳product_prices.php : 13 -> require_once
10 . SET time_zone = '+05:30' 0.0001 sec
↳product_prices.php : 13 -> require_once
11 . SELECT count(*) as active_langs FROM site_language where status = '1' 0.0001 sec
↳product_prices.php : 13 -> require_once
12 . SELECT shortname, site_language_id FROM site_language 0.0001 sec
↳product_prices.php : 13 -> require_once
13 . select TC.category_id, TCD.category_name from site_template_category as TC Left Join site_template_category_description AS TCD ON TCD.category_id = TC.category_id and TCD.site_language_id = '1' 0.0005 sec
↳product_prices.php : 13 -> require_once
14 . SELECT product_category.category_id, product_category_description.category_url as caturl, product_category_description.description, product_category_description.site_language_id FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category.status = '1' 0.0003 sec
↳product_prices.php : 13 -> require_once
15 . select p.products_id, pd.product_url as producturl,pd.products_title as productname, pd.site_language_id from products as p Left Join products_description as pd on pd.products_id = p.products_id 0.0014 sec
↳product_prices.php : 13 -> require_once
16 . SELECT * FROM product_info_layout ORDER BY layout_id ASC 0.0003 sec
↳product_prices.php : 13 -> require_once
17 . SELECT site_seo_description.seo_page_title, site_seo_description.seo_page_keywords,site_seo_description.seo_page_description FROM site_seo LEFT JOIN site_seo_description on site_seo_description.page_id = site_seo.page_id WHERE site_seo_description.site_language_id = 1 AND (site_seo.page_name = 'product_prices.php' OR site_seo.page_name = 'product_prices' OR site_seo.page_name = 'Default') ORDER BY site_seo.page_id desc 0.0007 sec
↳product_prices.php : 13 -> require_once
18 . SELECT site_general_metatag.name, site_general_metatag.content FROM site_general_metatag LEFT JOIN site_front_pages on site_front_pages.front_pages_id = site_general_metatag.page_id AND site_front_pages.seo_status = '1' WHERE (site_front_pages.front_pages_name = 'product_prices.php' OR site_front_pages.front_pages_name = 'product_prices') OR site_general_metatag.page_id = 0 ORDER BY site_front_pages.front_pages_id desc 0.0003 sec
↳product_prices.php : 13 -> require_once
19 . SELECT front_group_id FROM site_front_pages WHERE front_pages_name = 'product_prices' 0.0002 sec
↳product_prices.php : 13 -> require_once
20 . SELECT SQL_CALC_FOUND_ROWS * FROM (SELECT site_constants.constant_name, site_constants_description.constant_value, site_constants_description.constant_id, Concat(site_constants_description.constant_id, IF(site_constants_description.corporate_id = -1, 1, 0)) AS corporateid FROM site_constants LEFT JOIN site_constants_description ON site_constants_description.constant_id = site_constants.constant_id AND site_constants_description.site_language_id=1 LEFT JOIN site_front_page_group ON site_constants.front_group_id = site_front_page_group.front_group_id WHERE 1 AND site_constants.front_group_id IN ('1', '3') AND site_constants.available_to IN ('0', '11', '3', '12', '-2') AND site_constants_description.corporate_id = 0 GROUP BY corporateid ORDER BY corporateid DESC) AS site_constants_description GROUP BY site_constants_description.constant_id 0.0207 sec
↳product_prices.php : 13 -> require_once
21 . SELECT * FROM (SELECT menu_link.*, menu_link_description.menu_title,menu_link_description.menu_image,menu_link_description.site_language_id FROM menu_link LEFT JOIN menu_link_description ON menu_link_description.menu_id = menu_link.menu_id WHERE menu_link_description.site_language_id = 1 AND menu_link.status = '1' AND corporate_id = 0 AND (link_display = '2' OR link_display = '0') LIMIT 18446744073709551615) AS temp_table ORDER BY sort_order ASC 0.0005 sec
↳product_prices.php : 13 -> require_once
22 . SELECT * FROM sidebar_management WHERE section_pages LIKE '%|product_prices.php|%' AND corporate_id = 0 OR sidebar_id = '1' ORDER BY sidebar_id DESC LIMIT 1 OFFSET 0 0.0002 sec
↳product_prices.php : 13 -> require_once
23 . SELECT * FROM (SELECT side_menu_link. * FROM side_menu_link WHERE 1 AND corporate_id = 0 GROUP BY menu_title HAVING status = '1' AND menu_display IN ('0', '1') ORDER BY sortorder ASC, status ASC, menu_title ASC LIMIT 18446744073709551615 ) AS temp_table ORDER BY sortorder ASC, status ASC, menu_title ASC 0.0002 sec
↳product_prices.php : 13 -> require_once
24 . SELECT SQL_CALC_FOUND_ROWS * FROM corporate_user WHERE directory_name = 'product_prices.html' 0.0003 sec
↳product_prices.php : 13 -> require_once
25 . SELECT SQL_CALC_FOUND_ROWS cms_pages.page_name, cms_pages_description.page_heading, cms_pages_description.page_content, cms_pages.corporate_id FROM cms_pages LEFT JOIN cms_pages_description ON cms_pages_description.page_id = cms_pages.page_id WHERE cms_pages_description.site_language_id = 1 AND cms_pages.page_name IN ('cms_header', 'cms_middle_footer', 'cms_footer', 'contact_us_box', 'sidebar_content_left', 'sidebar_content_right', 'related_product_section_help', 'cms_social_media_links') AND cms_pages.status = '1' AND cms_pages.corporate_id = 0 ORDER BY corporate_id DESC 0.0004 sec
↳product_prices.php : 13 -> require_once
*******************************COMMON END*********************************
26 . SELECT SQL_CALC_FOUND_ROWS product_category.category_id, product_category_description.category_name, product_category_description.description, product_category.sort_order FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category_description.site_language_id = 1 AND product_category.status = '1' AND product_category.parent_id != 0 ORDER BY product_category.sort_order ASC, product_category.category_id ASC 0.0002 sec
↳product_prices.php : 108 -> ProductCategoryMaster::get_product_category_details
27 . SELECT products.products_id, products_sizes.size_id, products_sizes.size_title, product_price.price, product_price.qty, product_price.qty_to, product_price.corporate_id, product_price.user_type_id, products.predefined_product_type, products.price_defining_method, products.enable_sheet_calculation, product_price.color_page_price, products.enable_color_pages, product_price.extra_page_price, product_price.product_price_id, vendor_price.vendor_price,vendor_price.vendor_color_price,vendor_price.vendor_price_extra_page FROM products LEFT JOIN `product_price` ON `product_price`.`products_id` = `products`.`products_id` AND `product_price`.`visible` = '1' AND (`product_price`.`user_type_id` = '1') LEFT JOIN vendor_price ON vendor_price.price_id = product_price.product_price_id AND vendor_price.price_type='P' AND (products.user_type_id = '1' OR products.user_type_id = '0') RIGHT JOIN `products_sizes` ON `products_sizes`.`products_id` = `products`.`products_id` AND `products_sizes`.`size_id` = `product_price`.`size_id` AND `products_sizes`.`site_language_id` = 1 AND `products_sizes`.`visible`='1' WHERE IF ( `products`.`price_defining_method` IN ('1', '2', '3'), `product_price`.`qty_to` != 0, 1) AND products.predefined_product_type IN ('0', '11', '1', '3', '12') ORDER BY `products_sizes`.`sort_order` ASC, `product_price`.`corporate_id` DESC, `products`.`sort_order` ASC, `product_price`.`products_id` ASC, `product_price`.`qty` ASC 0.0293 sec
↳product_prices.php : 152 -> get_user_base_product_price
Array
(
[twd] => Array
(
[titletag] =>ABC PrintRoom: Product Prices
[metatag] =>
ABC PrintRoom 5290 Shawnee Road, Suite 300customerservice@abcprintroom.com
[cms_header] =>
Welcome to ABC PrintRoom! Your one stop print source for any occasion. Popular Products Start your print project today. Upload your own files or choose from our 3,500 customizable design templates.
[cms_middle_footer] =>
Weddings Family Albums Look Books Portfolios
Sign up for savings, join our eNewsletter
Watch Online Design Tool Video VIDEO
[related_product_section_help] =>
You might also like to view our other products...
)
[SITE_VAR_PRODUCT_NO_IMAGE] =>
[SITE_VAR_DISPLAY_PRODUCT_CATEGORY_SUBOPTION] => %s
(%s)
[SITE_VAR_CART_AGREE_CHECKBOX] => product_add_info
[SITE_VAR_PREDEFINED_PRODUCT_CHECKBOX] =>
[payonMethodIDs] => [22]
[productCategoryDetails] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT SQL_CALC_FOUND_ROWS product_category.category_id, product_category_description.category_name, product_category_description.description, product_category.sort_order FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category_description.site_language_id = :site_language_id AND product_category.status = :status AND product_category.parent_id != :product_category_parent_id ORDER BY product_category.sort_order ASC, product_category.category_id ASC
)
[AffectedRows:RDataRecordSet:private] => 6
[RecordCount] => 6
[foundRows] => 6
[RecordList:RDataRecordSet:private] => Array
(
)
[IteratorCount:RDataRecordSet:private] => 0
[last_query] => SELECT SQL_CALC_FOUND_ROWS product_category.category_id, product_category_description.category_name, product_category_description.description, product_category.sort_order FROM product_category LEFT JOIN product_category_description ON product_category_description.category_id = product_category.category_id WHERE product_category_description.site_language_id = 1 AND product_category.status = '1' AND product_category.parent_id != 0 ORDER BY product_category.sort_order ASC, product_category.category_id ASC
)
[price_list_page] => 3
[PriceDetails] => Array
(
[90] => Array
(
[0] => Array
(
[117] => None
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[None] => 3.99
)
[10] => Array
(
[size_id] => 10
[option_title] => 10
[None] => 30.99
)
[20] => Array
(
[size_id] => 20
[option_title] => 20
[None] => 61.99
)
[50] => Array
(
[size_id] => 50
[option_title] => 50
[None] => 144.99
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[None] => 269.99
)
)
[91] => Array
(
[0] => Array
(
[118] => None
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[None] => 12.49
)
[50] => Array
(
[size_id] => 50
[option_title] => 50
[None] => 504.49
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[None] => 1008.49
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[None] => 2362.49
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[None] => 4410.49
)
)
[97] => Array
(
[0] => Array
(
[126] => 8x10
[135] => 11x14
[136] => 16x20
[140] => 20x30
[141] => 30x40
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 100
[8x10] => 21.6
[11x14] => 46.3
[16x20] => 61.73
[20x30] => 92.59
[30x40] => 138.89
)
)
[98] => Array
(
[0] => Array
(
[128] => 5x7 Flat
)
[10] => Array
(
[size_id] => 10
[option_title] => 10
[5x7 Flat] => 16.4
)
[20] => Array
(
[size_id] => 20
[option_title] => 20
[5x7 Flat] => 12.49
)
[30] => Array
(
[size_id] => 30
[option_title] => 30
[5x7 Flat] => 44.6
)
[40] => Array
(
[size_id] => 40
[option_title] => 40
[5x7 Flat] => 56.5
)
[50] => Array
(
[size_id] => 50
[option_title] => 50
[5x7 Flat] => 67.1
)
[75] => Array
(
[size_id] => 75
[option_title] => 75
[5x7 Flat] => 95.7
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5x7 Flat] => 116.9
)
[125] => Array
(
[size_id] => 125
[option_title] => 125
[5x7 Flat] => 146.2
)
[150] => Array
(
[size_id] => 150
[option_title] => 150
[5x7 Flat] => 175.4
)
[175] => Array
(
[size_id] => 175
[option_title] => 175
[5x7 Flat] => 204.65
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[5x7 Flat] => 233.9
)
[225] => Array
(
[size_id] => 225
[option_title] => 225
[5x7 Flat] => 263.2
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[5x7 Flat] => 292.4
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[5x7 Flat] => 584.9
)
[750] => Array
(
[size_id] => 750
[option_title] => 750
[5x7 Flat] => 833.6
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[5x7 Flat] => 1055.9
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[5x7 Flat] => 1504.9
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[5x7 Flat] => 1905.9
)
[2500] => Array
(
[size_id] => 2500
[option_title] => 2500
[5x7 Flat] => 2263.4
)
[5000] => Array
(
[size_id] => 5000
[option_title] => 5000
[5x7 Flat] => 4073.9
)
[10000] => Array
(
[size_id] => 10000
[option_title] => 10000
[5x7 Flat] => 7332.9
)
)
[23] => Array
(
[0] => Array
(
[46] => 72x36
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[72x36] => 10
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[72x36] => 20
)
[300] => Array
(
[size_id] => 300
[option_title] => 300
[72x36] => 30
)
)
[66] => Array
(
[0] => Array
(
[92] => 24 x 24
[93] => 60 x 48
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[24 x 24] => 10
[60 x 48] => 15
)
)
[68] => Array
(
[0] => Array
(
[95] => 3 x 2
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[3 x 2] => 10
)
)
[74] => Array
(
[0] => Array
(
[101] => 5.5 x 8.5
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5.5 x 8.5] => 10
)
)
[83] => Array
(
[0] => Array
(
[110] => 3.25x4.25
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[3.25x4.25] => 10
)
)
[85] => Array
(
[0] => Array
(
[112] => Standard
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[Standard] => 10.99
)
[2] => Array
(
[size_id] => 2
[option_title] => 2
[Standard] => 16.99
)
[5] => Array
(
[size_id] => 5
[option_title] => 5
[Standard] => 24.99
)
)
[86] => Array
(
[0] => Array
(
[113] => Standard
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[Standard] => 15
)
[2] => Array
(
[size_id] => 2
[option_title] => 2
[Standard] => 25
)
)
[82] => Array
(
[0] => Array
(
[109] => 11.25x17.25
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[11.25x17.25] => 10
)
)
[67] => Array
(
[0] => Array
(
[94] => 2 x 2
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[2 x 2] => 10
)
)
[84] => Array
(
[0] => Array
(
[111] => S/M/L/XL
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[S/M/L/XL] => 0
)
)
[2001] => Array
(
[0] => Array
(
[143] => 10X10
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 100
[10X10] => 50
)
)
[92] => Array
(
[0] => Array
(
[119] => Standard
[120] => Backpack
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 50
[Standard] => 12
[Backpack] => 14
)
[51] => Array
(
[size_id] => 51
[option_title] => 51 - 100
[Standard] => 11
[Backpack] => 12
)
[101] => Array
(
[size_id] => 101
[option_title] => 101 - 500
[Standard] => 9
[Backpack] => 10
)
)
[96] => Array
(
[0] => Array
(
[124] => 8x8
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[8x8] => 29.99
)
)
[95] => Array
(
[0] => Array
(
[123] => 12x12
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[12x12] => 29.99
)
)
[94] => Array
(
[0] => Array
(
[122] => 8 x 11( Portrait)
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[8 x 11( Portrait)] => 29.99
)
)
[2000] => Array
(
[0] => Array
(
[115] => 8 x 11 (Landscape)
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[8 x 11 (Landscape)] => 64.95
)
)
[89] => Array
(
[0] => Array
(
[116] => 8 x 5.5
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 100
[8 x 5.5] => 24.99
)
)
[87] => Array
(
[0] => Array
(
[114] => 8x11
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 100
[8x11] => 24.99
)
)
[88] => Array
(
[0] => Array
(
[115] => 8 x 11 (Landscape)
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[8 x 11 (Landscape)] => 5
)
[2] => Array
(
[size_id] => 2
[option_title] => 2
[8 x 11 (Landscape)] => 10
)
[3] => Array
(
[size_id] => 3
[option_title] => 3
[8 x 11 (Landscape)] => 15
)
[4] => Array
(
[size_id] => 4
[option_title] => 4
[8 x 11 (Landscape)] => 20
)
[5] => Array
(
[size_id] => 5
[option_title] => 5
[8 x 11 (Landscape)] => 25
)
[10] => Array
(
[size_id] => 10
[option_title] => 10
[8 x 11 (Landscape)] => 40
)
[20] => Array
(
[size_id] => 20
[option_title] => 20
[8 x 11 (Landscape)] => 73
)
[50] => Array
(
[size_id] => 50
[option_title] => 50
[8 x 11 (Landscape)] => 130
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[8 x 11 (Landscape)] => 234
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[8 x 11 (Landscape)] => 405
)
)
[101] => Array
(
[0] => Array
(
[142] => 11x17
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[11x17] => 5
)
[2] => Array
(
[size_id] => 2
[option_title] => 2
[11x17] => 10
)
[3] => Array
(
[size_id] => 3
[option_title] => 3
[11x17] => 15
)
[4] => Array
(
[size_id] => 4
[option_title] => 4
[11x17] => 20
)
[5] => Array
(
[size_id] => 5
[option_title] => 5
[11x17] => 25
)
[10] => Array
(
[size_id] => 10
[option_title] => 10
[11x17] => 40
)
[20] => Array
(
[size_id] => 20
[option_title] => 20
[11x17] => 73
)
[50] => Array
(
[size_id] => 50
[option_title] => 50
[11x17] => 130
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[11x17] => 234
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[11x17] => 405
)
)
[24] => Array
(
[0] => Array
(
[23] => 18x24
)
[1] => Array
(
[size_id] => 1
[option_title] => 1 - 100
[18x24] => 62.5
)
)
[4] => Array
(
[0] => Array
(
[5] => 5 x 7
[37] => 4 x 6
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5 x 7] => 39.99
[4 x 6] => 29.99
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[5 x 7] => 65.99
[4 x 6] => 62.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[5 x 7] => 79.99
[4 x 6] => 73.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[5 x 7] => 108.99
[4 x 6] => 89.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[5 x 7] => 169.99
[4 x 6] => 159.99
)
)
[5] => Array
(
[0] => Array
(
[6] => 9.75 x 4.37
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[9.75 x 4.37] => 41.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[9.75 x 4.37] => 62.99
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[9.75 x 4.37] => 90.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[9.75 x 4.37] => 121.99
)
[2500] => Array
(
[size_id] => 2500
[option_title] => 2500
[9.75 x 4.37] => 159.99
)
)
[20] => Array
(
[0] => Array
(
[21] => 10 x 7
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[10 x 7] => 63.99
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[10 x 7] => 75.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[10 x 7] => 99.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[10 x 7] => 183.99
)
)
[36] => Array
(
[0] => Array
(
[58] => A4 - 8.25 x 11.67
[55] => A5 - 8.25x5.81
[57] => A4 - 8.5x11
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[A4 - 8.25 x 11.67] => 10
[A5 - 8.25x5.81] => 10
[A4 - 8.5x11] => 15
)
)
[37] => Array
(
[0] => Array
(
[59] => 5.25x8.5
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5.25x8.5] => 5.99
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[5.25x8.5] => 11.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[5.25x8.5] => 29.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[5.25x8.5] => 59.99
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[5.25x8.5] => 89.99
)
)
[22] => Array
(
[0] => Array
(
[22] => catalog_8.5 x 11
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[catalog_8.5 x 11] => 19.99
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[catalog_8.5 x 11] => 39.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[catalog_8.5 x 11] => 89.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[catalog_8.5 x 11] => 179.99
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[catalog_8.5 x 11] => 259.99
)
)
[26] => Array
(
[0] => Array
(
[24] => 5.25x8.5
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[5.25x8.5] => 5.99
)
[200] => Array
(
[size_id] => 200
[option_title] => 200
[5.25x8.5] => 11.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[5.25x8.5] => 29.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[5.25x8.5] => 59.99
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[5.25x8.5] => 89.99
)
)
[7] => Array
(
[0] => Array
(
[8] => 17x11_Half-fold
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[17x11_Half-fold] => 92.99
)
[250] => Array
(
[size_id] => 250
[option_title] => 250
[17x11_Half-fold] => 119.99
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[17x11_Half-fold] => 139.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[17x11_Half-fold] => 179.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[17x11_Half-fold] => 229.99
)
)
[2] => Array
(
[0] => Array
(
[50] => A5 - 8.25x5.81
[51] => A4 - 8.5x11
[3] => A4 - 8.25 x 11.67
)
[100] => Array
(
[size_id] => 100
[option_title] => 100
[A5 - 8.25x5.81] => 10
[A4 - 8.5x11] => 12
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[A4 - 8.25 x 11.67] => 111.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[A4 - 8.25 x 11.67] => 122.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[A4 - 8.25 x 11.67] => 171.99
)
[3000] => Array
(
[size_id] => 3000
[option_title] => 3000
[A4 - 8.25 x 11.67] => 221.99
)
[4000] => Array
(
[size_id] => 4000
[option_title] => 4000
[A4 - 8.25 x 11.67] => 269.99
)
)
[3] => Array
(
[0] => Array
(
[4] => A4 - 8.27 x 11.69
)
[500] => Array
(
[size_id] => 500
[option_title] => 500
[A4 - 8.27 x 11.69] => 169.99
)
[1000] => Array
(
[size_id] => 1000
[option_title] => 1000
[A4 - 8.27 x 11.69] => 187.99
)
[1500] => Array
(
[size_id] => 1500
[option_title] => 1500
[A4 - 8.27 x 11.69] => 217.99
)
[2000] => Array
(
[size_id] => 2000
[option_title] => 2000
[A4 - 8.27 x 11.69] => 261.99
)
[2500] => Array
(
[size_id] => 2500
[option_title] => 2500
[A4 - 8.27 x 11.69] => 301.99
)
)
[100] => Array
(
[0] => Array
(
[134] => 2x3
)
[1] => Array
(
[size_id] => 1
[option_title] => 1
[2x3] => 4
)
[2] => Array
(
[size_id] => 2
[option_title] => 2
[2x3] => 3
)
)
)
[ProductData] =>
[show_price_if_login] => 1
[SITE_VAR_PRODUCT_DISCOUNT_PATTERN] =>
[SITE_VAR_BOOK_MODULE_ENABLE] =>
)
)
*******************************Render TPL Start*********************************
28 . SELECT * FROM website_logos WHERE corporate_id = 0 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
Render > header_toplinks.block Array
(
[twd] => Array
(
[cnt] => 0
[menus] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 64
[menu_link] => cms.php?page=contact_us
[menu_target] => _self
[menu_position] => topheader
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 0
[menu_link_category] => 1
[link_type_id] => 10
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => 202.559.7454
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 7
[menu_link] => user_account.php
[menu_target] => _self
[menu_position] => topheader
[link_display] => 0
[menu_option] => 2
[status] => 1
[sort_order] => 1
[menu_link_category] => 4
[link_type_id] => 36
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Login / Register
[menu_image] => fa-user
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 37
[menu_link] => express_checkout_payment.php
[menu_target] => _self
[menu_position] => topheader
[link_display] => 2
[menu_option] => 2
[status] => 1
[sort_order] => 8
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Shopping Cart
[menu_image] => fa-shopping-cart
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
)
[arr_myaccount_menu_link] => Array
(
[0] => user_account.php
[1] => user_order.php
[3] => user_portfolio.php
[4] => quote.php
[5] => user_order_inventory.php
[7] => user_reward.php
[8] => user_images.php
[9] => user_qrcode_list.php
[10] => user_address.php
[11] => user_profile.php
[12] => user_store_profile.php
[13] => sales_order_report.php
[14] => user_changepassword.php
)
[form] => Array
(
[fb_button] => 29 . SELECT * FROM site_language WHERE status = '1' 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
30 . SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC 0.0012 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
31 . SELECT product_category.category_id,product_category.category_pro_enable,product_category.category_pro_pattern,product_category_description.category_promotional_text FROM product_category_description LEFT JOIN product_category ON product_category.category_id = product_category_description.category_id WHERE product_category.status = '1' AND product_category.parent_id = '0' AND product_category_description.site_language_id = 1 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
32 . SELECT SQL_CALC_FOUND_ROWS * FROM product_kit LEFT JOIN product_kit_description ON product_kit_description.kit_id = product_kit.kit_id AND product_kit_description.site_language_id = 1 WHERE (product_kit.user_type_id = '1' OR product_kit.user_type_id = '0') AND product_kit.status = 1 ORDER BY product_kit.sort_order ASC, product_kit.kit_id ASC 0.0004 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
Render > header_menu.block Array
(
[twd] => Array
(
[cnt] => 0
[menus] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 2
[menu_link] => product_list.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 2
[status] => 1
[sort_order] => 0
[menu_link_category] => 6
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Products
[menu_image] => fa-list
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 70
[menu_link] => cms.php?page=photobooks
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 1
[menu_link_category] => 1
[link_type_id] => 99
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => photo books
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 69
[menu_link] => cms.php?page=calendar
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 2
[menu_link_category] => 1
[link_type_id] => 97
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => calendars
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 3
[menu_link] => product_prices.php
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 3
[menu_link_category] => 2
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Pricing
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 44
[menu_link] => cms.php?page=contact_us
[menu_target] => _self
[menu_position] => header
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 5
[menu_link_category] => 1
[link_type_id] => 10
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Contact us
[menu_image] => fa-envelope-o
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
)
[arr_myaccount_menu_link] => Array
(
[0] => user_account.php
[1] => user_order.php
[3] => user_portfolio.php
[4] => quote.php
[5] => user_order_inventory.php
[7] => user_reward.php
[8] => user_images.php
[9] => user_qrcode_list.php
[10] => user_address.php
[11] => user_profile.php
[12] => user_store_profile.php
[13] => sales_order_report.php
[14] => user_changepassword.php
)
[form] => Array
(
[fb_button] => Render > product_category_group.block Array
(
[twd] => Array
(
[product_count] => 20
[FArray] => Array
(
[0] => product_info.php
[1] => product_design_upload.php
[2] => product_designs.php
[3] => corporate_products.php
)
[productCategoryDetails] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 20
[RecordCount] => 20
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => canvasprints
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 97
[predefined_product_type] => 0
[products_title] => Canvas Prints
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => square-magnets
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 68
[predefined_product_type] => 0
[products_title] => Square Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 67
[predefined_product_type] => 0
[products_title] => Custom Shape Magnet
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => test-photoprint-product
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2001
[predefined_product_type] => 12
[products_title] => Test Photoprint Product
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 96
[predefined_product_type] => 3
[products_title] => Photo Book (8x8)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 95
[predefined_product_type] => 3
[products_title] => Photo Book (12x12)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-portrait
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 94
[predefined_product_type] => 3
[products_title] => Photo Book (Portrait)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-landscape
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2000
[predefined_product_type] => 3
[products_title] => Photo Book (Landscape)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 23
[predefined_product_type] => 0
[products_title] => Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => postcards
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 4
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => yard-sign-banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 66
[predefined_product_type] => 0
[products_title] => Yard Sign Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => car-door-magnets
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 82
[predefined_product_type] => 0
[products_title] => Car Door Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => catalogs-both-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 22
[predefined_product_type] => 0
[products_title] => Catalogs Both Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 26
[predefined_product_type] => 0
[products_title] => Door Hangers Two Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => brochures
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 7
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => flyers-one-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2
[predefined_product_type] => 0
[products_title] => Flyers One Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 11
[product_url] => posters
[category_id] => 11
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Posters, Banners & Signs
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 24
[predefined_product_type] => 0
[products_title] => Posters
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => envelopes
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 5
[predefined_product_type] => 0
[products_title] => Envelopes
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => greeting-cards
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 20
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => letterhead
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 3
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
)
[IteratorCount:RDataRecordSet:private] => 20
[last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[CATEGORY_LAYOUT_ENABLED] => toggle
[category_product] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[cat_id] => 10
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[cat_id] => 10
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[cat_id] => 8
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[cat_id] => 3
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[cat_id] => 11
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[cat_id] => 2
[product_url] => letterhead
)
)
)
)
[selected_category] =>
[allgroupcategorys] => RDataRecordSet Object
(
[ResultData:RDataRecordSet:private] => PDOStatement Object
(
[queryString] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = :pcd_site_language_id) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = :pp_status LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = :pcd_site_language_id1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = :products_description_site_language_id) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = :product_category_status AND products.visible = :products_visible_2 AND products.products_id != :products_id_quote AND products.predefined_product_type IN (:input_0, :input_1, :input_2, :input_3, :input_4) AND products.product_service_type NOT IN (:input_5, :input_6, :input_7, :input_8) AND (products.user_type_id = :products_corporate_id_1 OR products.user_type_id = :products_user_type_id_0) ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[AffectedRows:RDataRecordSet:private] => 20
[RecordCount] => 20
[foundRows] => -1
[RecordList:RDataRecordSet:private] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => canvasprints
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 97
[predefined_product_type] => 0
[products_title] => Canvas Prints
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => square-magnets
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 68
[predefined_product_type] => 0
[products_title] => Square Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[2] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 10
[product_url] => custom-shape-magnet
[category_id] => 10
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Specialty Products
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 67
[predefined_product_type] => 0
[products_title] => Custom Shape Magnet
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[3] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => test-photoprint-product
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2001
[predefined_product_type] => 12
[products_title] => Test Photoprint Product
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[4] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-8x8-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 96
[predefined_product_type] => 3
[products_title] => Photo Book (8x8)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[5] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => square-photo-book-12x12-inch
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 95
[predefined_product_type] => 3
[products_title] => Photo Book (12x12)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[6] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-portrait
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 94
[predefined_product_type] => 3
[products_title] => Photo Book (Portrait)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[7] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 8
[product_url] => photobook-landscape
[category_id] => 8
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Photo Books
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2000
[predefined_product_type] => 3
[products_title] => Photo Book (Landscape)
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[8] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 23
[predefined_product_type] => 0
[products_title] => Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[9] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => postcards
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 4
[predefined_product_type] => 0
[products_title] => Postcards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[10] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => yard-sign-banners
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 66
[predefined_product_type] => 0
[products_title] => Yard Sign Banners
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[11] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => car-door-magnets
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 82
[predefined_product_type] => 0
[products_title] => Car Door Magnets
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[12] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => catalogs-both-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 22
[predefined_product_type] => 0
[products_title] => Catalogs Both Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[13] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => door-hangers-two-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 26
[predefined_product_type] => 0
[products_title] => Door Hangers Two Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[14] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => brochures
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 7
[predefined_product_type] => 0
[products_title] => Brochures
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[15] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 3
[product_url] => flyers-one-side
[category_id] => 3
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Marketing Materials
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 2
[predefined_product_type] => 0
[products_title] => Flyers One Side
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[16] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 11
[product_url] => posters
[category_id] => 11
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Posters, Banners & Signs
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 24
[predefined_product_type] => 0
[products_title] => Posters
[product_promotional_text] =>
[setting_constant_name] => PRODUCT_PROMOTION_IN_TITLE
[setting_value] => no
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[17] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => envelopes
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 5
[predefined_product_type] => 0
[products_title] => Envelopes
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[18] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => greeting-cards
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 20
[predefined_product_type] => 0
[products_title] => Greeting Cards
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
[19] => RDataRecord Object
(
[_Data:protected] => Array
(
[group_srt] =>
[cat_id] => 2
[product_url] => letterhead
[category_id] => 2
[category_pro_enable] => 0
[multiple_category] =>
[category_name] => Business Stationary
[category_promotional_text] =>
[parent_id] => -1
[products_id] => 3
[predefined_product_type] => 0
[products_title] => Letterhead
[product_promotional_text] =>
[setting_constant_name] =>
[setting_value] =>
[group_name] =>
)
[_IteratorKeys:protected] => Array
(
[0] => group_srt
[1] => cat_id
[2] => product_url
[3] => category_id
[4] => category_pro_enable
[5] => multiple_category
[6] => category_name
[7] => category_promotional_text
[8] => parent_id
[9] => products_id
[10] => predefined_product_type
[11] => products_title
[12] => product_promotional_text
[13] => setting_constant_name
[14] => setting_value
[15] => group_name
)
)
)
[IteratorCount:RDataRecordSet:private] => 20
[last_query] => SELECT pp.sort_order AS group_srt,products.category_id as cat_id, products_description.product_url,product_category.category_id,product_category.category_pro_enable,products.multiple_category,product_category_description.category_name,product_category_description.category_promotional_text,product_category.parent_id, products.products_id, products.predefined_product_type, products_description.products_title,products_description.product_promotional_text,product_settings.setting_constant_name,product_settings.setting_value,pcd.category_name AS group_name FROM products LEFT JOIN product_category ON products.category_id = product_category.category_id OR (find_in_set(product_category.category_id,products.multiple_category) > 0) LEFT JOIN product_category_description ON (product_category_description.category_id = product_category.category_id AND product_category_description.site_language_id = 1) LEFT JOIN product_category pp ON pp.category_id = product_category.parent_id AND pp.status = '1' LEFT JOIN product_category_description pcd ON pcd.category_id = product_category.parent_id AND pp.status = '1' AND pcd.site_language_id = 1 LEFT JOIN products_description ON (products_description.products_id = products.products_id AND products_description.site_language_id = 1) LEFT JOIN product_settings ON (product_settings.products_id = products.products_id AND product_settings.setting_constant_name = 'PRODUCT_PROMOTION_IN_TITLE') WHERE product_category.status = '1' AND products.visible = '1' AND products.products_id != '-11' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products.product_service_type NOT IN ('2', '3', '4', '5') AND (products.user_type_id = '1' OR products.user_type_id = '0') ORDER BY -group_srt DESC, product_category.sort_order ASC, product_category.parent_id ASC, product_category.category_id ASC, products.sort_order ASC,products_description.products_title ASC, products.products_id ASC
)
[group_categorys] => Array
(
[-1] => Array
(
[group_name] =>
[group_enable] =>
[group_pro_text] =>
[groups] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[product_url] => letterhead
)
)
)
)
)
)
[category_with_group] => Array
(
)
[category_without_group_name] => Array
(
[10] => Array
(
[category_name] => Specialty Products
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[97] => Array
(
[pname] => Canvas Prints
[pro_enable] => no
[pro_title] =>
[product_url] => canvasprints
)
[68] => Array
(
[pname] => Square Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => square-magnets
)
[67] => Array
(
[pname] => Custom Shape Magnet
[pro_enable] =>
[pro_title] =>
[product_url] => custom-shape-magnet
)
)
)
[8] => Array
(
[category_name] => Photo Books
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[2001] => Array
(
[pname] => Test Photoprint Product
[pro_enable] =>
[pro_title] =>
[product_url] => test-photoprint-product
)
[96] => Array
(
[pname] => Photo Book (8x8)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-8x8-inch
)
[95] => Array
(
[pname] => Photo Book (12x12)
[pro_enable] =>
[pro_title] =>
[product_url] => square-photo-book-12x12-inch
)
[94] => Array
(
[pname] => Photo Book (Portrait)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-portrait
)
[2000] => Array
(
[pname] => Photo Book (Landscape)
[pro_enable] =>
[pro_title] =>
[product_url] => photobook-landscape
)
)
)
[3] => Array
(
[category_name] => Marketing Materials
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[23] => Array
(
[pname] => Banners
[pro_enable] =>
[pro_title] =>
[product_url] => banners
)
[4] => Array
(
[pname] => Postcards
[pro_enable] =>
[pro_title] =>
[product_url] => postcards
)
[66] => Array
(
[pname] => Yard Sign Banners
[pro_enable] =>
[pro_title] =>
[product_url] => yard-sign-banners
)
[82] => Array
(
[pname] => Car Door Magnets
[pro_enable] =>
[pro_title] =>
[product_url] => car-door-magnets
)
[22] => Array
(
[pname] => Catalogs Both Side
[pro_enable] =>
[pro_title] =>
[product_url] => catalogs-both-side
)
[26] => Array
(
[pname] => Door Hangers Two Side
[pro_enable] =>
[pro_title] =>
[product_url] => door-hangers-two-side
)
[7] => Array
(
[pname] => Brochures
[pro_enable] =>
[pro_title] =>
[product_url] => brochures
)
[2] => Array
(
[pname] => Flyers One Side
[pro_enable] =>
[pro_title] =>
[product_url] => flyers-one-side
)
)
)
[11] => Array
(
[category_name] => Posters, Banners & Signs
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[24] => Array
(
[pname] => Posters
[pro_enable] => no
[pro_title] =>
[product_url] => posters
)
)
)
[2] => Array
(
[category_name] => Business Stationary
[cat_enable] => 0
[cat_pro_text] =>
[products] => Array
(
[5] => Array
(
[pname] => Envelopes
[pro_enable] =>
[pro_title] =>
[product_url] => envelopes
)
[20] => Array
(
[pname] => Greeting Cards
[pro_enable] =>
[pro_title] =>
[product_url] => greeting-cards
)
[3] => Array
(
[pname] => Letterhead
[pro_enable] =>
[pro_title] =>
[product_url] => letterhead
)
)
)
)
[select_group] =>
[select_category_product] =>
)
)
33 . SELECT SQL_CALC_FOUND_ROWS * FROM banner_image_setting 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
34 . SELECT SQL_CALC_FOUND_ROWS banner_image.* FROM banner_image LEFT JOIN site_language ON site_language.site_language_id = banner_image.banner_language WHERE (banner_image.banner_start_date = '0' OR (banner_image.banner_start_date <= '2024-04-25 04:28:45' AND banner_image.banner_end_date >= '2024-04-25 04:28:45')) AND (FIND_IN_SET('product_prices.php',banner_image.banner_pages)) AND banner_image.corporate_id = 0 AND banner_image.banner_language IN (1, 0) AND banner_image.status = '1' ORDER BY sort_order ASC 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
Array
(
[twd] => Array
(
[section] => top
[index_top_section_details] => 1
[banner_settings] => Array
(
[bannerWidth] => auto
[bannerHeight] => auto
[autoStart] => 1
[timeout] => 6000
[showPrevNextLinks] => 1
[showPagerLinks] => 1
[bannerDescLeftPosition] => auto
[bannerDescTopPosition] => auto
[bannerEffect] => slide
[bannerDisplayType] => 1
[bannerSelection] => 0
)
[res_banner] => Array
(
)
[banner_advance_settings] =>
)
)
35 . SELECT * FROM breadcrumbs WHERE status = '1' 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
36 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 10 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0005 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
37 . SELECT coupon.*, IF (coupon.product_id != 'all',1,2) AS OrderBY FROM coupon WHERE coupon.type = 'discount' AND coupon.coupon_type = 'product' AND '2024-04-25 04:28:46' BETWEEN coupon.coupon_start_date AND coupon.coupon_end_dateAND coupon.coupon_status = '1' ORDER BY OrderBY, user_discount_group_id DESC, coupon_start_date DESC , coupon_id DESC 0.01 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
38 . SELECT * FROM product_settings WHERE products_id = 97 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
39 . SELECT * FROM product_settings WHERE products_id = 97 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
40 . SELECT * FROM product_settings WHERE products_id = 97 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
41 . SELECT * FROM product_settings WHERE products_id = 97 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
42 . SELECT * FROM product_settings WHERE products_id = 97 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
43 . SELECT * FROM product_settings WHERE products_id = 68 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
44 . SELECT * FROM product_settings WHERE products_id = 67 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
45 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 9 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
46 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 8 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
47 . SELECT * FROM product_settings WHERE products_id = 2001 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
48 . SELECT * FROM product_settings WHERE products_id = 96 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
49 . SELECT * FROM product_settings WHERE products_id = 95 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
50 . SELECT * FROM product_settings WHERE products_id = 94 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
51 . SELECT * FROM product_settings WHERE products_id = 2000 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
52 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 3 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
53 . SELECT * FROM product_settings WHERE products_id = 23 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
54 . SELECT * FROM product_settings WHERE products_id = 23 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
55 . SELECT * FROM product_settings WHERE products_id = 23 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
56 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
57 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
58 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
59 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
60 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
61 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
62 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
63 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
64 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
65 . SELECT * FROM product_settings WHERE products_id = 4 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
66 . SELECT * FROM product_settings WHERE products_id = 66 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
67 . SELECT * FROM product_settings WHERE products_id = 66 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
68 . SELECT * FROM product_settings WHERE products_id = 82 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
69 . SELECT * FROM product_settings WHERE products_id = 22 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
70 . SELECT * FROM product_settings WHERE products_id = 22 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
71 . SELECT * FROM product_settings WHERE products_id = 22 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
72 . SELECT * FROM product_settings WHERE products_id = 22 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
73 . SELECT * FROM product_settings WHERE products_id = 22 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
74 . SELECT * FROM product_settings WHERE products_id = 26 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
75 . SELECT * FROM product_settings WHERE products_id = 26 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
76 . SELECT * FROM product_settings WHERE products_id = 26 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
77 . SELECT * FROM product_settings WHERE products_id = 26 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
78 . SELECT * FROM product_settings WHERE products_id = 26 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
79 . SELECT * FROM product_settings WHERE products_id = 7 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
80 . SELECT * FROM product_settings WHERE products_id = 7 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
81 . SELECT * FROM product_settings WHERE products_id = 7 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
82 . SELECT * FROM product_settings WHERE products_id = 7 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
83 . SELECT * FROM product_settings WHERE products_id = 7 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
84 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
85 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
86 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
87 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
88 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
89 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
90 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
91 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
92 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
93 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
94 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
95 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
96 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
97 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
98 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
99 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
100 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
101 . SELECT * FROM product_settings WHERE products_id = 2 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
102 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 11 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0003 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
103 . SELECT * FROM product_settings WHERE products_id = 24 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
104 . SELECT products.products_id, products_description.products_title, products.predefined_product_type FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id LEFT JOIN product_price ON product_price.products_id = products.products_id WHERE products.visible = '1' AND products.predefined_product_type IN ('0', '11', '1', '3', '12') AND products_description.site_language_id = 1 AND product_price.visible = '1' AND (products.user_type_id = '1' OR products.user_type_id = '0') AND products.category_id = 2 GROUP BY products.products_id ORDER BY products.sort_order ASC, products_description.products_title ASC, products.products_id ASC 0.0002 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
105 . SELECT * FROM product_settings WHERE products_id = 5 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
106 . SELECT * FROM product_settings WHERE products_id = 5 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
107 . SELECT * FROM product_settings WHERE products_id = 5 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
108 . SELECT * FROM product_settings WHERE products_id = 5 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
109 . SELECT * FROM product_settings WHERE products_id = 5 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
110 . SELECT * FROM product_settings WHERE products_id = 20 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
111 . SELECT * FROM product_settings WHERE products_id = 20 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
112 . SELECT * FROM product_settings WHERE products_id = 20 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
113 . SELECT * FROM product_settings WHERE products_id = 20 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
114 . SELECT * FROM product_settings WHERE products_id = 3 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
115 . SELECT * FROM product_settings WHERE products_id = 3 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
116 . SELECT * FROM product_settings WHERE products_id = 3 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
117 . SELECT * FROM product_settings WHERE products_id = 3 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
118 . SELECT * FROM product_settings WHERE products_id = 3 AND setting_constant_name IN ('PRODUCT_MINIMUM_PRICE') 0.0001 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
Render > footer_links.block Array
(
[twd] => Array
(
[cnt] => 0
[menus] => Array
(
[0] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 13
[menu_link] => cms.php?page=privacy_policy
[menu_target] => _self
[menu_position] => footer
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 5
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Privacy Policy
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
[1] => RDataRecord Object
(
[_Data:protected] => Array
(
[menu_id] => 14
[menu_link] => cms.php?page=terms_of_use
[menu_target] => _self
[menu_position] => footer
[link_display] => 2
[menu_option] => 0
[status] => 1
[sort_order] => 14
[menu_link_category] => 0
[link_type_id] => 0
[master_menu_id] => 0
[corporate_id] => 0
[menu_title] => Terms & Conditions
[menu_image] =>
[site_language_id] => 1
)
[_IteratorKeys:protected] => Array
(
[0] => menu_id
[1] => menu_link
[2] => menu_target
[3] => menu_position
[4] => link_display
[5] => menu_option
[6] => status
[7] => sort_order
[8] => menu_link_category
[9] => link_type_id
[10] => master_menu_id
[11] => corporate_id
[12] => menu_title
[13] => menu_image
[14] => site_language_id
)
)
)
[arr_myaccount_menu_link] => Array
(
[0] => user_account.php
[1] => user_order.php
[3] => user_portfolio.php
[4] => quote.php
[5] => user_order_inventory.php
[7] => user_reward.php
[8] => user_images.php
[9] => user_qrcode_list.php
[10] => user_address.php
[11] => user_profile.php
[12] => user_store_profile.php
[13] => sales_order_report.php
[14] => user_changepassword.php
)
[form] => Array
(
[fb_button] => 119 . SELECT * FROM (SELECT promotional_message.promotional_id,promotional_category,promotional_message_description.title,promotional_message_description.description,style_type,status,section_name,promo_cookie,promo_settings FROM promotional_messageLEFT JOIN promotional_message_description ON promotional_message_description.promotional_id = promotional_message.promotional_id WHERE 1 AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1' AND (user_type = '1' OR user_type = '0') AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2024-04-25 04:28:46' AND promotional_message.promotion_end_date >= '2024-04-25 04:28:46')) AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND promotional_message.section_name LIKE 'product_prices.php' OR (promotional_message.promotional_category = '14' AND (user_type = '1' OR user_type = '0') AND (promotional_message.promotion_start_date = '0' OR (promotional_message.promotion_start_date <= '2024-04-25 04:28:46' AND promotional_message.promotion_end_date >= '2024-04-25 04:28:46'))AND (promotional_message.promotional_display = '2' OR promotional_message.promotional_display = '0' ) AND promotional_message_description.site_language_id = 1 AND promotional_message.status = '1') ORDER BY FIELD(promotional_category,'14','13','12',promotional_category),promotional_message.promotional_id DESC LIMIT 18446744073709551615) AS a group by promotional_category LIMIT 0,1 0.0007 sec
↳product_prices.php : 439 -> Twig_Environment::render (mainpage.tpl )
