Array
(
[0] => Array
(
[total_queries] => 22
[total_query_time] => 0.023486
[1] => Array
(
[query] => SHOW TABLES FROM `figaro_ecommerce`;
[result] => Resource id #17
[query_time] => 0.001351
[error] =>
[rows] => 79
[fields] => 1
[insert_id] =>
)
[2] => Array
(
[query] => SELECT `iq_user_vehicles`.`vehicle_id` FROM `iq_user_vehicles` WHERE user_id =
[result] =>
[query_time] => 0.000245
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[3] => Array
(
[query] => SELECT `figaro_group_products`.`product_id` FROM `figaro_group_products` WHERE group_id = 416
[result] => Resource id #29
[query_time] => 0.000152
[error] =>
[rows] => 21
[fields] => 1
[insert_id] =>
)
[4] => Array
(
[query] => SELECT DISTINCT `iq_vehicles`.`year` FROM `iq_vehicles` WHERE 1 = 1 ORDER BY year DESC
[result] => Resource id #31
[query_time] => 0.000257
[error] =>
[rows] => 48
[fields] => 1
[insert_id] =>
)
[5] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price` FROM `figaro_product_prices` WHERE product_id IN (4766,4767,4768,4769,4770,4771,4772,4773,4774,4775,4776,4777,4778,4779,4780,4781,4782,9468,9469,9470,9471) AND store_id = 12
[result] => Resource id #32
[query_time] => 0.000973
[error] =>
[rows] => 21
[fields] => 2
[insert_id] =>
)
[6] => Array
(
[query] => SELECT `figaro_product_images`.`id`, `figaro_product_images`.`product_id`, `figaro_product_images`.`image`, `figaro_product_images`.`primary_image` FROM `figaro_product_images` WHERE product_id = 4766
[result] => Resource id #33
[query_time] => 0.00026
[error] =>
[rows] => 1
[fields] => 4
[insert_id] =>
)
[7] => Array
(
[query] => SELECT `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id = 4766 AND store_id = 12
[result] => Resource id #34
[query_time] => 0.000559
[error] =>
[rows] => 1
[fields] => 3
[insert_id] =>
)
[8] => Array
(
[query] => select p.id,
p.partnumber,
p.name,
p.product_type_id AS type_id,
pt.name AS type_name,
p.description,
p.created,
p.updated,
pw.weight,
pb.id AS brand_id,
b.name AS brand_name,
g.name AS group_name,
gp.group_id AS group_id,
AVG(pr.review_score) AS average_score
from figaro_products p
left join figaro_product_types pt on pt.id = p.product_type_id
left join figaro_product_weights pw on pw.product_id = p.id
left join figaro_product_brands pb on pb.product_id= p.id
left join figaro_brands b on b.id = pb.brand_id
left join figaro_product_reviews pr on pr.partnumber = p.partnumber
left join figaro_group_products gp on gp.product_id = p.id
left join figaro_groups g on g.id = gp.group_id
where p.id = 4766
GROUP BY p.id
[result] => Resource id #35
[query_time] => 0.017031
[error] =>
[rows] => 1
[fields] => 14
[insert_id] =>
)
[9] => Array
(
[query] => SELECT `figaro_products`.`product_type_id` FROM `figaro_products` WHERE id = 4766
[result] => Resource id #36
[query_time] => 0.00026
[error] =>
[rows] => 1
[fields] => 1
[insert_id] =>
)
[10] => Array
(
[query] => SELECT `figaro_product_type_specifications`.`id`, `figaro_product_type_specifications`.`product_type_id`, `figaro_product_type_specifications`.`rank`, `figaro_product_type_specifications`.`name`, `figaro_product_type_specifications`.`default_value`, `figaro_product_type_specifications`.`snapshot` FROM `figaro_product_type_specifications` WHERE product_type_id = 44 ORDER BY rank ASC
[result] => Resource id #37
[query_time] => 0.000159
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[11] => Array
(
[query] => SELECT `figaro_product_specifications`.`id`, `figaro_product_specifications`.`product_id`, `figaro_product_specifications`.`product_type_specification_id`, `figaro_product_specifications`.`value`, `figaro_product_specifications`.`created`, `figaro_product_specifications`.`updated` FROM `figaro_product_specifications` WHERE product_id = 4766
[result] => Resource id #38
[query_time] => 0.000122
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[12] => Array
(
[query] => SELECT `figaro_product_type_features`.`id`, `figaro_product_type_features`.`product_type_id`, `figaro_product_type_features`.`rank`, `figaro_product_type_features`.`feature`, `figaro_product_type_features`.`snapshot`, `figaro_product_type_features`.`created`, `figaro_product_type_features`.`updated` FROM `figaro_product_type_features` WHERE product_type_id = 44 ORDER BY rank ASC
[result] => Resource id #39
[query_time] => 0.000141
[error] =>
[rows] => 0
[fields] => 7
[insert_id] =>
)
[13] => Array
(
[query] => SELECT `figaro_product_features`.`id`, `figaro_product_features`.`product_id`, `figaro_product_features`.`rank`, `figaro_product_features`.`feature`, `figaro_product_features`.`created`, `figaro_product_features`.`updated` FROM `figaro_product_features` WHERE product_id = 4766 ORDER BY rank ASC
[result] => Resource id #40
[query_time] => 0.00012
[error] =>
[rows] => 2
[fields] => 6
[insert_id] =>
)
[14] => Array
(
[query] => SELECT `figaro_product_type_included`.`id`, `figaro_product_type_included`.`product_type_id`, `figaro_product_type_included`.`rank`, `figaro_product_type_included`.`value`, `figaro_product_type_included`.`created`, `figaro_product_type_included`.`updated` FROM `figaro_product_type_included` WHERE product_type_id = 44 ORDER BY rank ASC
[result] => Resource id #41
[query_time] => 0.000135
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[15] => Array
(
[query] => SELECT `figaro_product_included`.`id`, `figaro_product_included`.`product_id`, `figaro_product_included`.`rank`, `figaro_product_included`.`value`, `figaro_product_included`.`created`, `figaro_product_included`.`updated` FROM `figaro_product_included` WHERE product_id = 4766 ORDER BY rank ASC
[result] => Resource id #42
[query_time] => 0.00012
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[16] => Array
(
[query] => SELECT `figaro_product_type_not_included`.`id`, `figaro_product_type_not_included`.`product_type_id`, `figaro_product_type_not_included`.`rank`, `figaro_product_type_not_included`.`value`, `figaro_product_type_not_included`.`created`, `figaro_product_type_not_included`.`updated` FROM `figaro_product_type_not_included` WHERE product_type_id = 44 ORDER BY rank ASC
[result] => Resource id #43
[query_time] => 0.00014
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[17] => Array
(
[query] => SELECT `figaro_product_not_included`.`id`, `figaro_product_not_included`.`product_id`, `figaro_product_not_included`.`rank`, `figaro_product_not_included`.`value`, `figaro_product_not_included`.`created`, `figaro_product_not_included`.`updated` FROM `figaro_product_not_included` WHERE product_id = 4766 ORDER BY rank ASC
[result] => Resource id #44
[query_time] => 0.00012
[error] =>
[rows] => 0
[fields] => 6
[insert_id] =>
)
[18] => Array
(
[query] => SELECT `figaro_product_footnotes`.`id`, `figaro_product_footnotes`.`product_id`, `figaro_product_footnotes`.`rank`, `figaro_product_footnotes`.`footnote`, `figaro_product_footnotes`.`created`, `figaro_product_footnotes`.`updated` FROM `figaro_product_footnotes` WHERE product_id = 4766 ORDER BY rank ASC
[result] => Resource id #45
[query_time] => 0.000121
[error] =>
[rows] => 1
[fields] => 6
[insert_id] =>
)
[19] => Array
(
[query] => select sql_no_cache user_id, product_id, quantity, bundle_id from figaro_user_carts where user_id = order by id
[result] =>
[query_time] => 0.000857
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by id' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[20] => Array
(
[query] => SELECT `figaro_product_prices`.`product_id`, `figaro_product_prices`.`list_price`, `figaro_product_prices`.`your_price`, `figaro_product_prices`.`bundle_savings` FROM `figaro_product_prices` WHERE product_id IN () AND store_id = 12
[result] =>
[query_time] => 0.000201
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND store_id = 12' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[21] => Array
(
[query] => select sql_no_cache * from figaro_orders_live where user_id =
[result] =>
[query_time] => 9E-05
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
[22] => Array
(
[query] => select sql_no_cache promo_id from figaro_user_promos where user_id =
[result] =>
[query_time] => 7.2E-05
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[rows] =>
[fields] =>
[insert_id] =>
)
)
)
)
Add just $25.00 worth of merchandise to receive FREE UPS GROUND shipping!
