Code | Context

$place	=	"pages-home"
$type	=	"shop"
$plugin	=	false
$jsCombined	=	array(
	array(
	"file" => "universal_1_jquery.js",
	"path" => "/home/content/s/a/v/savisites/html/eric/app/webroot/js/"
),
	array(
	"file" => "universal_2_layout.js",
	"path" => "/home/content/s/a/v/savisites/html/eric/app/webroot/js/"
),
	array(
	"file" => "shop_1_base.js",
	"path" => "/home/content/s/a/v/savisites/html/eric/app/webroot/js/"
)
)
$toReplace	=	"/home/content/s/a/v/savisites/html/eric/app/webroot/"
$value	=	"/js/universal_1_jquery.js"
$key	=	0
$newPath	=	"/js/"
$newJsCombined	=	array(
	"/js/universal_1_jquery.js",
	"/js/universal_2_layout.js",
	"/js/shop_1_base.js"
)
$js	=	""

        $js = '';
        foreach($newJsCombined as $key=>$value) {
            if($_REQUEST['url']=='admin/admin_settings/edit') {

HeaderHelper::_make_js() - APP/views/helpers/header.php, line 137
HeaderHelper::make() - APP/views/helpers/header.php, line 64
include - APP/views/layouts/shop.ctp, line 9
View::_render() - CORE/cake/libs/view/view.php, line 646
View::renderLayout() - CORE/cake/libs/view/view.php, line 442
View::render() - CORE/cake/libs/view/view.php, line 380
Controller::render() - CORE/cake/libs/controller/controller.php, line 733
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 260
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 230
[main] - APP/webroot/index.php, line 85

Makes a Great Holiday Gift!!!

Featured Items

View INTERACTIVE Book

Great for any child

Hocky Mom's

The Story of Christmas

The Sports Book

My Wedding Memories

Site developed by SaviSites and powered by BakeSale

app/views/layouts/shop.ctp (line 59)

Array
(
    [Config] => Array
        (
            [userAgent] => 
            [time] => 1227800471
            [rand] => 1790359171
            [timeout] => 10
        )

    [Order] => Array
        (
            [session] => 1790359171
            [country_id] => 2
            [shipping_method_id] => 5
            [payment_method_id] => 1
        )

)

app/views/layouts/shop.ctp (line 60)

Array
(
    [pass] => Array
        (
        )

    [named] => Array
        (
        )

    [plugin] => 
    [controller] => pages
    [action] => home
    [url] => Array
        (
            [ext] => html
            [url] => /
        )

    [form] => Array
        (
        )

    [isAjax] => 
    [models] => Array
        (
        )

)

80 queries took 237 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `bs_admin_settings`	3	3	2
2	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0	0	2
3	SELECT `AdminSetting`.`id`, `AdminSetting`.`key`, `AdminSetting`.`value` FROM `bs_admin_settings` AS `AdminSetting` WHERE `AdminSetting`.`key` = 'template' LIMIT 1	1	1	7
4	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	4
5	INSERT INTO `bs_cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', 1227800472, 'adn5s6v74arnpdj0qlnsv05tl3')	1		33
6	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
7	SELECT `AdminSetting`.`id`, `AdminSetting`.`key`, `AdminSetting`.`value` FROM `bs_admin_settings` AS `AdminSetting` WHERE `AdminSetting`.`key` = 'template_color' LIMIT 1	1	1	1
8	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
9	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		7
10	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
11	DESCRIBE `bs_admin_home_edits`	15	15	10
12	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	6
13	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		5
14	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	9
15	select * from bs_admin_home_edits	1	1	10
16	DESCRIBE `bs_products`	29	29	5
17	DESCRIBE `bs_brands`	5	5	4
18	DESCRIBE `bs_line_items`	11	11	2
19	DESCRIBE `bs_orders`	34	34	2
20	DESCRIBE `bs_orders_fields`	33	33	5
21	DESCRIBE `bs_subproducts`	9	9	5
22	DESCRIBE `bs_categories`	11	11	8
23	DESCRIBE `bs_categories_products`	2	2	5
24	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
25	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
26	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
27	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
28	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
29	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
30	SELECT `Home`.`featured1`, `Home`.`featured2`, `Home`.`featured3`, `Home`.`featured4`, `Home`.`featured5`, `Home`.`featured6` FROM `bs_admin_home_edits` AS `Home` WHERE 1 = 1	1	1	1
31	select id , images from bs_products where id in (32,24,28,20,18,34)	6	6	4
32	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
33	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		14
34	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
35	DESCRIBE `bs_custom_images`	4	4	2
36	DESCRIBE `bs_custom_fields`	4	4	1
37	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
38	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800474 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1		7
39	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
40	SELECT `CustomField`.`id`, `CustomField`.`custom_value`, `CustomField`.`meta_description`, `CustomField`.`meta_keywords` FROM `bs_custom_fields` AS `CustomField` WHERE 1 = 1	1	1	1
41	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
42	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800474 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
43	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
44	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
45	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800475 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1		13
46	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
47	DESCRIBE `bs_contents`	16	16	2
48	DESCRIBE `bs_content_categories`	9	9	2
49	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
50	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800475 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		5
51	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
52	SELECT `Content`.`id`, `Content`.`content_category_id`, `Content`.`active`, `Content`.`sort`, `Content`.`name`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`description`, `Content`.`url`, `Content`.`video_active`, `Content`.`video`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`images`, `Content`.`created`, `Content`.`modified`, `ContentCategory`.`id`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`active`, `ContentCategory`.`name`, `ContentCategory`.`description`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `bs_contents` AS `Content` LEFT JOIN `bs_content_categories` AS `ContentCategory` ON (`Content`.`content_category_id` = `ContentCategory`.`id`) WHERE `Content`.`active` = 1 AND `content_category_id` = 1 ORDER BY `Content`.`sort` ASC	3	3	2
53	DESCRIBE `bs_shipping_methods`	8	8	3
54	DESCRIBE `bs_shipping_rules`	8	8	2
55	DESCRIBE `bs_countries`	8	8	1
56	DESCRIBE `bs_countries_shipping_methods`	2	2	1
57	DESCRIBE `bs_payment_methods`	8	8	1
58	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
59	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800475 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
60	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
61	SELECT `Country`.`id`, `Country`.`active`, `Country`.`code`, `Country`.`code3`, `Country`.`sort`, `Country`.`name`, `Country`.`created`, `Country`.`modified` FROM `bs_countries` AS `Country` WHERE `active` = 1 ORDER BY `sort` ASC LIMIT 1	1	1	1
62	SELECT `ShippingMethod`.`id`, `ShippingMethod`.`active`, `ShippingMethod`.`sort`, `ShippingMethod`.`price`, `ShippingMethod`.`processor`, `ShippingMethod`.`name`, `ShippingMethod`.`created`, `ShippingMethod`.`modified`, `CountriesShippingMethod`.`country_id`, `CountriesShippingMethod`.`shipping_method_id` FROM `bs_shipping_methods` AS `ShippingMethod` JOIN `bs_countries_shipping_methods` AS `CountriesShippingMethod` ON (`CountriesShippingMethod`.`country_id` = 2 AND `CountriesShippingMethod`.`shipping_method_id` = `ShippingMethod`.`id`) WHERE 1 = 1 ORDER BY `ShippingMethod`.`sort` ASC	7	7	1
63	SELECT `Country`.`id`, `Country`.`active`, `Country`.`code`, `Country`.`code3`, `Country`.`sort`, `Country`.`name`, `Country`.`created`, `Country`.`modified` FROM `bs_countries` AS `Country` WHERE `Country`.`id` = 2 LIMIT 1	1	1	1
64	SELECT `ShippingMethod`.`id`, `ShippingMethod`.`active`, `ShippingMethod`.`sort`, `ShippingMethod`.`price`, `ShippingMethod`.`processor`, `ShippingMethod`.`name`, `ShippingMethod`.`created`, `ShippingMethod`.`modified`, `CountriesShippingMethod`.`country_id`, `CountriesShippingMethod`.`shipping_method_id` FROM `bs_shipping_methods` AS `ShippingMethod` JOIN `bs_countries_shipping_methods` AS `CountriesShippingMethod` ON (`CountriesShippingMethod`.`country_id` = 2 AND `CountriesShippingMethod`.`shipping_method_id` = `ShippingMethod`.`id`) WHERE 1 = 1 ORDER BY `ShippingMethod`.`sort` ASC	7	7	1
65	SELECT `PaymentMethod`.`id`, `PaymentMethod`.`active`, `PaymentMethod`.`price`, `PaymentMethod`.`sort`, `PaymentMethod`.`processor`, `PaymentMethod`.`name`, `PaymentMethod`.`created`, `PaymentMethod`.`modified` FROM `bs_payment_methods` AS `PaymentMethod` WHERE `active` = 1 ORDER BY `sort` ASC LIMIT 1	1	1	1
66	SELECT `Order`.`id`, `Order`.`club_member_id`, `Order`.`shipping_method_id`, `Order`.`payment_method_id`, `Order`.`country_id`, `Order`.`session`, `Order`.`number`, `Order`.`firstname`, `Order`.`lastname`, `Order`.`email`, `Order`.`phone`, `Order`.`address`, `Order`.`postcode`, `Order`.`city`, `Order`.`state`, `Order`.`country`, `Order`.`s_firstname`, `Order`.`s_lastname`, `Order`.`s_address`, `Order`.`s_postcode`, `Order`.`s_city`, `Order`.`s_state`, `Order`.`s_country`, `Order`.`shipping_method`, `Order`.`shipping_price`, `Order`.`payment_method`, `Order`.`payment_price`, `Order`.`state_tax`, `Order`.`state_tax2`, `Order`.`discount`, `Order`.`total_purchase`, `Order`.`comments`, `Order`.`created`, `Order`.`modified` FROM `bs_orders` AS `Order` WHERE `session` = '1790359171' LIMIT 1	0	0	5
67	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
68	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}Order\|a:4:{s:7:\"session\";i:1790359171;s:10:\"country_id\";s:1:\"2\";s:18:\"shipping_method_id\";s:1:\"5\";s:17:\"payment_method_id\";s:1:\"1\";}', `expires` = 1227800476 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1		10
69	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
70	SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`active`, `Category`.`sort`, `Category`.`name`, `Category`.`description`, `Category`.`images`, `Category`.`created`, `Category`.`modified` FROM `bs_categories` AS `Category` WHERE `Category`.`parent_id` = 0 AND `Category`.`active` = 1 ORDER BY `Category`.`lft` ASC	7	7	1
71	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
72	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}Order\|a:4:{s:7:\"session\";i:1790359171;s:10:\"country_id\";s:1:\"2\";s:18:\"shipping_method_id\";s:1:\"5\";s:17:\"payment_method_id\";s:1:\"1\";}', `expires` = 1227800476 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
73	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
74	SELECT `Brand`.`id`, `Brand`.`active`, `Brand`.`name`, `Brand`.`created`, `Brand`.`modified` FROM `bs_brands` AS `Brand` WHERE `active` = 1	4	4	0
75	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
76	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}Order\|a:4:{s:7:\"session\";i:1790359171;s:10:\"country_id\";s:1:\"2\";s:18:\"shipping_method_id\";s:1:\"5\";s:17:\"payment_method_id\";s:1:\"1\";}', `expires` = 1227800476 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1
77	SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	0
78	SELECT `Content`.`id`, `Content`.`content_category_id`, `Content`.`active`, `Content`.`sort`, `Content`.`name`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`description`, `Content`.`url`, `Content`.`video_active`, `Content`.`video`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`images`, `Content`.`created`, `Content`.`modified`, `ContentCategory`.`id`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`active`, `ContentCategory`.`name`, `ContentCategory`.`description`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `bs_contents` AS `Content` LEFT JOIN `bs_content_categories` AS `ContentCategory` ON (`Content`.`content_category_id` = `ContentCategory`.`id`) WHERE `Content`.`active` = 1 AND `content_category_id` = 3 ORDER BY `Content`.`sort` ASC	6	6	1
79	SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	1	1	1
80	UPDATE `bs_cake_sessions` SET `data` = 'Config\|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}Order\|a:4:{s:7:\"session\";i:1790359171;s:10:\"country_id\";s:1:\"2\";s:18:\"shipping_method_id\";s:1:\"5\";s:17:\"payment_method_id\";s:1:\"1\";}', `expires` = 1227800476 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'	0		1

80 queries took 237 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `bs_admin_settings`

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `AdminSetting`.`id`, `AdminSetting`.`key`, `AdminSetting`.`value` FROM `bs_admin_settings` AS `AdminSetting` WHERE `AdminSetting`.`key` = 'template' LIMIT 1

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

INSERT INTO `bs_cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', 1227800472, 'adn5s6v74arnpdj0qlnsv05tl3')

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `AdminSetting`.`id`, `AdminSetting`.`key`, `AdminSetting`.`value` FROM `bs_admin_settings` AS `AdminSetting` WHERE `AdminSetting`.`key` = 'template_color' LIMIT 1

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

UPDATE `bs_cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}', `expires` = 1227800472 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

DESCRIBE `bs_admin_home_edits`

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

select * from bs_admin_home_edits

DESCRIBE `bs_products`

DESCRIBE `bs_brands`

DESCRIBE `bs_line_items`

DESCRIBE `bs_orders`

DESCRIBE `bs_orders_fields`

DESCRIBE `bs_subproducts`

DESCRIBE `bs_categories`

DESCRIBE `bs_categories_products`

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `Home`.`featured1`, `Home`.`featured2`, `Home`.`featured3`, `Home`.`featured4`, `Home`.`featured5`, `Home`.`featured6` FROM `bs_admin_home_edits` AS `Home` WHERE 1 = 1

select id , images from bs_products where id in (32,24,28,20,18,34)

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

DESCRIBE `bs_custom_images`

DESCRIBE `bs_custom_fields`

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `CustomField`.`id`, `CustomField`.`custom_value`, `CustomField`.`meta_description`, `CustomField`.`meta_keywords` FROM `bs_custom_fields` AS `CustomField` WHERE 1 = 1

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

DESCRIBE `bs_contents`

DESCRIBE `bs_content_categories`

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `Content`.`id`, `Content`.`content_category_id`, `Content`.`active`, `Content`.`sort`, `Content`.`name`, `Content`.`meta_description`, `Content`.`meta_keywords`, `Content`.`description`, `Content`.`url`, `Content`.`video_active`, `Content`.`video`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`images`, `Content`.`created`, `Content`.`modified`, `ContentCategory`.`id`, `ContentCategory`.`parent_id`, `ContentCategory`.`lft`, `ContentCategory`.`rght`, `ContentCategory`.`active`, `ContentCategory`.`name`, `ContentCategory`.`description`, `ContentCategory`.`created`, `ContentCategory`.`modified` FROM `bs_contents` AS `Content` LEFT JOIN `bs_content_categories` AS `ContentCategory` ON (`Content`.`content_category_id` = `ContentCategory`.`id`) WHERE `Content`.`active` = 1 AND `content_category_id` = 1 ORDER BY `Content`.`sort` ASC

DESCRIBE `bs_shipping_methods`

DESCRIBE `bs_shipping_rules`

DESCRIBE `bs_countries`

DESCRIBE `bs_countries_shipping_methods`

DESCRIBE `bs_payment_methods`

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `Country`.`id`, `Country`.`active`, `Country`.`code`, `Country`.`code3`, `Country`.`sort`, `Country`.`name`, `Country`.`created`, `Country`.`modified` FROM `bs_countries` AS `Country` WHERE `active` = 1 ORDER BY `sort` ASC LIMIT 1

SELECT `ShippingMethod`.`id`, `ShippingMethod`.`active`, `ShippingMethod`.`sort`, `ShippingMethod`.`price`, `ShippingMethod`.`processor`, `ShippingMethod`.`name`, `ShippingMethod`.`created`, `ShippingMethod`.`modified`, `CountriesShippingMethod`.`country_id`, `CountriesShippingMethod`.`shipping_method_id` FROM `bs_shipping_methods` AS `ShippingMethod` JOIN `bs_countries_shipping_methods` AS `CountriesShippingMethod` ON (`CountriesShippingMethod`.`country_id` = 2 AND `CountriesShippingMethod`.`shipping_method_id` = `ShippingMethod`.`id`) WHERE 1 = 1 ORDER BY `ShippingMethod`.`sort` ASC

SELECT `PaymentMethod`.`id`, `PaymentMethod`.`active`, `PaymentMethod`.`price`, `PaymentMethod`.`sort`, `PaymentMethod`.`processor`, `PaymentMethod`.`name`, `PaymentMethod`.`created`, `PaymentMethod`.`modified` FROM `bs_payment_methods` AS `PaymentMethod` WHERE `active` = 1 ORDER BY `sort` ASC LIMIT 1

SELECT `Order`.`id`, `Order`.`club_member_id`, `Order`.`shipping_method_id`, `Order`.`payment_method_id`, `Order`.`country_id`, `Order`.`session`, `Order`.`number`, `Order`.`firstname`, `Order`.`lastname`, `Order`.`email`, `Order`.`phone`, `Order`.`address`, `Order`.`postcode`, `Order`.`city`, `Order`.`state`, `Order`.`country`, `Order`.`s_firstname`, `Order`.`s_lastname`, `Order`.`s_address`, `Order`.`s_postcode`, `Order`.`s_city`, `Order`.`s_state`, `Order`.`s_country`, `Order`.`shipping_method`, `Order`.`shipping_price`, `Order`.`payment_method`, `Order`.`payment_price`, `Order`.`state_tax`, `Order`.`state_tax2`, `Order`.`discount`, `Order`.`total_purchase`, `Order`.`comments`, `Order`.`created`, `Order`.`modified` FROM `bs_orders` AS `Order` WHERE `session` = '1790359171' LIMIT 1

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

UPDATE `bs_cake_sessions` SET `data` = 'Config|a:4:{s:9:\"userAgent\";s:0:\"\";s:4:\"time\";i:1227800471;s:4:\"rand\";i:1790359171;s:7:\"timeout\";i:10;}Order|a:4:{s:7:\"session\";i:1790359171;s:10:\"country_id\";s:1:\"2\";s:18:\"shipping_method_id\";s:1:\"5\";s:17:\"payment_method_id\";s:1:\"1\";}', `expires` = 1227800476 WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`active`, `Category`.`sort`, `Category`.`name`, `Category`.`description`, `Category`.`images`, `Category`.`created`, `Category`.`modified` FROM `bs_categories` AS `Category` WHERE `Category`.`parent_id` = 0 AND `Category`.`active` = 1 ORDER BY `Category`.`lft` ASC

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `Brand`.`id`, `Brand`.`active`, `Brand`.`name`, `Brand`.`created`, `Brand`.`modified` FROM `bs_brands` AS `Brand` WHERE `active` = 1

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT `bs_cake_sessions`.`data` FROM `bs_cake_sessions` WHERE `bs_cake_sessions`.`id` = 'adn5s6v74arnpdj0qlnsv05tl3'

SELECT COUNT(id) AS count FROM `bs_cake_sessions` WHERE `id` = 'adn5s6v74arnpdj0qlnsv05tl3'