22 |
mysqli_query(object(mysqli), 'SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where
categories_relation_table.id=shop_products_categories.shop_category_id and
shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where
shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where
shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where
shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where
extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and
shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where
shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where
related_products_all_relation_table.id=shop_related_products.related_product_id and
shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where
shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where
customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and
shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id
LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id
LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id
LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id
LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id
WHERE
(shop_products.enabled=1 and (disable_completely is null or disable_completely=0)) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or (
shop_products.enable_customer_group_filter = 1 and
exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1')
))) AND (((shop_products.enabled=1 and (shop_products.grouped is null or shop_products.grouped=0) and not (
shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0))
)) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1
and not (
grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0))
)))) ORDER BY
created_at desc LIMIT 0, 4') |
/phproad/modules/db/classes/db_mysqlidriver.php |
105 |
21 |
Db_MySQLiDriver->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where
categories_relation_table.id=shop_products_categories.shop_category_id and
shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where
shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where
shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where
shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where
extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and
shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where
shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where
related_products_all_relation_table.id=shop_related_products.related_product_id and
shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where
shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where
customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and
shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id
LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id
LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id
LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id
LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id
WHERE
(shop_products.enabled=1 and (disable_completely is null or disable_completely=0)) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or (
shop_products.enable_customer_group_filter = 1 and
exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1')
))) AND (((shop_products.enabled=1 and (shop_products.grouped is null or shop_products.grouped=0) and not (
shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0))
)) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1
and not (
grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0))
)))) ORDER BY
created_at desc LIMIT 0, 4') |
/phproad/modules/db/classes/db_sqlbase.php |
636 |
20 |
Db_SqlBase->execute('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where
categories_relation_table.id=shop_products_categories.shop_category_id and
shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where
shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where
shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where
shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where
extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and
shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where
shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where
related_products_all_relation_table.id=shop_related_products.related_product_id and
shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where
shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where
customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and
shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id
LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id
LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id
LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id
LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id
WHERE
(shop_products.enabled=1 and (disable_completely is null or disable_completely=0)) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or (
shop_products.enable_customer_group_filter = 1 and
exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1')
))) AND (((shop_products.enabled=1 and (shop_products.grouped is null or shop_products.grouped=0) and not (
shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0))
)) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1
and not (
grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0))
)))) ORDER BY
created_at desc LIMIT 0, 4') |
/phproad/modules/db/classes/db_sqlbase.php |
462 |
19 |
Db_SqlBase->query('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where
categories_relation_table.id=shop_products_categories.shop_category_id and
shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where
shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where
shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where
shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where
extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and
shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where
shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where
related_products_all_relation_table.id=shop_related_products.related_product_id and
shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where
shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where
customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and
shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id
LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id
LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id
LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id
LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id
WHERE
(shop_products.enabled=1 and (disable_completely is null or disable_completely=0)) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or (
shop_products.enable_customer_group_filter = 1 and
exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1')
))) AND (((shop_products.enabled=1 and (shop_products.grouped is null or shop_products.grouped=0) and not (
shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0))
)) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1
and not (
grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0))
)))) ORDER BY
created_at desc LIMIT 0, 4') |
/phproad/modules/db/classes/db_sqlbase.php |
526 |
18 |
Db_SqlBase->fetchAll('SELECT (pages.url) as page_url, (0) as items_ordered, (if (shop_products.grouped = 1, concat(shop_products.name, " (", shop_products.grouped_option_desc, ")"), shop_products.name)) as grouped_name, (page_calculated_join.title) as page_calculated, (product_type_calculated_join.name) as product_type_calculated, (manufacturer_link_calculated_join.name) as manufacturer_link_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='images')) as images_calculated, (tax_class_calculated_join.name) as tax_class_calculated, (select group_concat(categories_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_categories as categories_relation_table, shop_products_categories where
categories_relation_table.id=shop_products_categories.shop_category_id and
shop_products_categories.shop_product_id=shop_products.id) as categories_calculated, (select group_concat(shop_products.grouped_option_desc ORDER BY 1 SEPARATOR ', ') from shop_products where
shop_products.product_id = shop_products.id) as grouped_products_all_calculated, (select group_concat(shop_custom_attributes.name ORDER BY 1 SEPARATOR ', ') from shop_custom_attributes where
shop_custom_attributes.product_id = shop_products.id) as options_calculated, (select group_concat(shop_extra_options.description ORDER BY 1 SEPARATOR ', ') from shop_extra_options where
shop_extra_options.product_id = shop_products.id and ((option_in_set is null or option_in_set=0))) as product_extra_options_calculated, (select group_concat(extra_option_sets_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_extra_option_sets as extra_option_sets_relation_table, shop_products_extra_sets where
extra_option_sets_relation_table.id=shop_products_extra_sets.extra_option_set_id and
shop_products_extra_sets.extra_product_id=shop_products.id) as extra_option_sets_calculated, (select group_concat(shop_tier_prices.id ORDER BY 1 SEPARATOR ', ') from shop_tier_prices where
shop_tier_prices.product_id = shop_products.id) as price_tiers_calculated, (select group_concat(related_products_all_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_products as related_products_all_relation_table, shop_related_products where
related_products_all_relation_table.id=shop_related_products.related_product_id and
shop_related_products.master_product_id=shop_products.id) as related_products_all_calculated, (select group_concat(shop_product_properties.name ORDER BY 1 SEPARATOR ', ') from shop_product_properties where
shop_product_properties.product_id = shop_products.id) as properties_calculated, (select group_concat(db_files.name ORDER BY 1 SEPARATOR ', ') from db_files where
db_files.master_object_id = shop_products.id and (master_object_class='Shop_Product' and field='files')) as files_calculated, (select group_concat(customer_groups_relation_table.name ORDER BY 1 SEPARATOR ', ') from shop_customer_groups as customer_groups_relation_table, shop_products_customer_groups where
customer_groups_relation_table.id=shop_products_customer_groups.customer_group_id and
shop_products_customer_groups.shop_product_id=shop_products.id) as customer_groups_calculated, (select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.updated_user_id) as updated_user_name, (trim(ifnull((select trim(concat(ifnull(firstName, ''), ' ', ifnull(lastName, ' '), ' ', ifnull(middleName, ''))) from users where users.id=shop_products.created_user_id), ''))) as created_user_name, shop_products.* FROM shop_products LEFT JOIN pages ON shop_products.page_id=pages.id
LEFT JOIN pages as page_calculated_join ON page_calculated_join.id = shop_products.page_id
LEFT JOIN shop_product_types as product_type_calculated_join ON product_type_calculated_join.id = shop_products.product_type_id
LEFT JOIN shop_manufacturers as manufacturer_link_calculated_join ON manufacturer_link_calculated_join.id = shop_products.manufacturer_id
LEFT JOIN shop_tax_classes as tax_class_calculated_join ON tax_class_calculated_join.id = shop_products.tax_class_id
WHERE
(shop_products.enabled=1 and (disable_completely is null or disable_completely=0)) AND (shop_products.visibility_catalog is not null and shop_products.visibility_catalog=1) AND (((shop_products.enable_customer_group_filter is null or shop_products.enable_customer_group_filter=0) or (
shop_products.enable_customer_group_filter = 1 and
exists(select * from shop_products_customer_groups where shop_product_id=shop_products.id and customer_group_id='1')
))) AND (((shop_products.enabled=1 and (shop_products.grouped is null or shop_products.grouped=0) and not (
shop_products.track_inventory is not null and shop_products.track_inventory=1 and shop_products.hide_if_out_of_stock is not null and shop_products.hide_if_out_of_stock=1 and ((shop_products.stock_alert_threshold is not null and shop_products.total_in_stock <= shop_products.stock_alert_threshold) or (shop_products.stock_alert_threshold is null and shop_products.total_in_stock<=0))
)) or exists(select * from shop_products grouped_products where grouped_products.product_id is not null and grouped_products.product_id=shop_products.id and grouped_products.enabled=1
and not (
grouped_products.track_inventory is not null and grouped_products.track_inventory=1 and grouped_products.hide_if_out_of_stock is not null and grouped_products.hide_if_out_of_stock=1 and ((grouped_products.stock_alert_threshold is not null and grouped_products.total_in_stock <= grouped_products.stock_alert_threshold) or (grouped_products.stock_alert_threshold is null and grouped_products.total_in_stock<=0))
)))) ORDER BY
created_at desc LIMIT 0, 4') |
/phproad/modules/db/classes/db_activerecord.php |
562 |
17 |
Db_ActiveRecord->find_all_internal(null, array(0), null) |
/phproad/modules/db/classes/db_activerecord.php |
583 |
16 |
Db_ActiveRecord->find_all(()) |
/modules/cms/classes/cms_controller.php(389) : eval()'d code |
9 |
15 |
eval(()) |
/modules/cms/classes/cms_controller.php |
389 |
14 |
Cms_Controller->evalWithException('?><div class="sidebox-title">
New Products
</div>
<div class="container-fluid">
<?
//Get the six newest products
$products = Shop_Product::create()->apply_filters();
$products->order('created_at desc');
$products = $products->limit(4)->find_all();
$this->render_partial('shop:product_side_list', array('products'=>$products, 'paginate'=>false))
?>
</div>', 'CMS partial', 'shop:product_side_new', array(0)) |
/modules/cms/classes/cms_controller.php |
1046 |
13 |
Cms_Controller->render_partial('shop:product_side_new') |
/modules/cms/classes/cms_controller.php(389) : eval()'d code |
21 |
12 |
eval(()) |
/modules/cms/classes/cms_controller.php |
389 |
11 |
Cms_Controller->evalWithException('?>
</div>
<div class="col-sm-3 hidden-xs">
<div class="sidebox">
<!--<div class="sidebox-title">
Delivery
</div>-->
<div class="sidebox-content delivery-box">
<a href="<?= root_url('delivery-and-returns') ?>">
<img src="<?= theme_resource_url('images/delivery-map4.gif') ?>" alt="Delivery">
</a>
</div>
</div>
<!--<div class="sidebox">
<div class="sidebox-content card-box">
<img src="<?= theme_resource_url('images/card-logos.jpg') ?>" alt="Delivery">
</div>
</div>-->
<? $this->render_partial('shop:product_side_featured', array('group_code'=>'featured_side')) ?>
<? $this->render_partial('shop:product_side_new') ?>
</div>
</div>
<div class="row footer">
<div class="col-xs-12 footer-inner">
<div class="row">
<div class="col-xs-12 col-sm-4">
<div class="footer-title">
Contact
</div>
<div class="footer-menu footer-contact">
<ul>
<li>
Email: <a href="mailto:[email protected]" itemprop="email">[email protected]</a>
</li>
<li>
Telephone: <a href="tel:01656742739" itemprop="telephone">01656 742 739</a>
</li>
<li>Admin Address: <span itemprop="name">Lawn and Power Limited</span>, <span itemtype="http://schema.org/PostalAddress" itemscope itemprop="address"><span itemprop="streetAddress">9 Wheatley Rd</span>, <span itemprop="addressLocality">Cardiff</span>, <span itemprop="addressRegion">Cardiff</span>, <span itemprop="postalCode">CF5 4LT</span></span></li>
<li>
Company Number: 10288966<br />
</li>
<li>
VAT Number: 248 1630 09
</li>
</ul>
<!--<div class="footer-title">
Newsletter Sign Up
</div>
<div class="footer-content">
<form action="#">
<input type="text" class="newsletter-input">
<button>Subscribe</button>
</form>
</div>-->
</div>
</div>
<div class="col-xs-12 col-sm-8">
<div class="container-fluid">
<div class="row">
<div class="col-xs-6 col-sm-4">
<div class="footer-title">
Social Media
</div>
<div class="footer-social">
<a href="https://www.facebook.com/lawnandpower/" class="social-button" target="new"><span class="icon-facebook"></span>Facebook</a>
<!--<a href="#" class="social-button" target="new"><span class="icon-twitter"></span>Twitter</a>-->
<a href="https://www.youtube.com/channel/UCljOfRsRDIrzRC2G_xu2f2A/videos?sort=dd&shelf_id=0&view=0" class="social-button" target="new"><span class="icon-youtube"></span>YouTube</a>
<!--<a href="https://plus.google.com/109907967481550044752" class="social-button" target="new"><span class="icon-googleplus"></span>Google Plus</a>-->
<a href="mailto:[email protected]" class="social-button"><span class="icon-mail"></span>Email</a>
</div>
</div>
<div class="col-xs-6 col-sm-4">
<div class="footer-title">
Helpful Info
</div>
<div class="footer-menu">
<ul>
<li><a href="<?= root_url('help-and-guides') ?>">Help and Guides</a></li>
<li><a href="<?= root_url('delivery-and-returns') ?>">Delivery, Return & Refund Policies</a></li>
<li><a href="<?= root_url('privacy-policy') ?>">Privacy / Cookie Policy</a></li>
<li><a href="<?= root_url('terms') ?>">Terms and Conditions</a></li>
<li><a href="<?= root_url('about') ?>">About Us</a></li>
<li><a href="<?= root_url('contact') ?>">Contact Us</a></li>
</ul>
</div>
</div>
<div class="col-xs-6 col-sm-4">
<div class="footer-title">
Store
</div>
<div class="footer-menu">
<ul>
<li><a href="<?= root_url('login') ?>">Login</a></li>
<li><a href="<?= root_url('cart') ?>">Basket</a></li>
<? if ($this->customer): ?>
<li><a href="<?= root_url('logout') ?>">Logout</a></li>
<? else: ?>
<li><a href="<?= root_url('login') ?>">My Account</a></li>
<? endif ?>
</ul>
<p>Payments accepted: Visa, Visa Debit, Mastercard and Mastercard Debit</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="footer-cwd"><a href="http://www.centurywebdesign.co.uk/" target="_blank">Website Design and Hosting by Century Web Design</a></div>
</div>
</div>
<noscript><img height="1" width="1" alt="" style="display:none" src="https://www.facebook.com/tr?id=1875927959286334&ev=PageView&noscript=1"/></noscript>
<?= $this->js_combine(array(
'@javascript/jquery.cookie.js',
'@javascript/jquery.hoverIntent.minified.js',
'@javascript/jquery.dcjqaccordion.2.9.min.js'
)) ?>
<script type="text/javascript">
$(document).ready(function($){
$('.sub-menu').dcAccordion({
eventType: 'click',
autoClose: true,
saveState: true,
disableLink: false,
speed: 'slow',
showCount: false,
autoExpand: true,
cookie: 'sub-menu-state',
classExpand: 'sub-menu-current-parent',
separateArrow: true
});
});
</script>
<script>(function(w,d,t,r,u){var f,n,i;w[u]=w[u]||[],f=function(){var o={ti:"5901756"};o.q=w[u],w[u]=new UET(o),w[u].push("pageLoad")},n=d.createElement(t),n.src=r,n.async=1,n.onload=n.onreadystatechange=function(){var s=this.readyState;s&&s!=="loaded"&&s!=="complete"||(f(),n.onload=n.onreadystatechange=null)},i=d.getElementsByTagName(t)[0],i.parentNode.insertBefore(n,i)})(window,document,"script","//bat.bing.com/bat.js","uetq");</script><noscript><img src="//bat.bing.com/action/0?ti=5901756&Ver=2" height="0" width="0" alt="" style="display:none; visibility: hidden;" /></noscript>
<script>
$('.submenu-link').click(function(e) {
e.preventDefault();
});
</script>
<?= CookieAgreement_Module::init_cookie_control() ?>
', 'CMS partial', 'layout:footer', array(0)) |
/modules/cms/classes/cms_controller.php |
1046 |
10 |
Cms_Controller->render_partial('layout:footer') |
/modules/cms/classes/cms_controller.php(389) : eval()'d code |
9 |
9 |
eval(()) |
/modules/cms/classes/cms_controller.php |
389 |
8 |
Cms_Controller->evalWithException('?><!DOCTYPE html>
<html lang="en">
<head>
<? $this->render_partial('layout:head') ?>
</head>
<body class="<?= isset($body_class) ? $body_class : null ?>" itemscope itemtype="http://schema.org/Store">
<? $this->render_partial('layout:header', array('title_area'=>true)) ?>
<? $this->render_page() ?>
<? $this->render_partial('layout:footer') ?>
</body>
</html>', 'CMS template', 'inner') |
/modules/cms/classes/cms_controller.php |
216 |
7 |
Cms_Controller->open(object(Cms_Page), array(2) [0 => 'brands', 1 => 'honda']) |
/controllers/application.php |
72 |
6 |
Application->On404(()) |
/phproad/modules/phpr/classes/phpr_controller.php |
174 |
5 |
Phpr_Controller->executeAction('On404', array(0)) |
/phproad/modules/phpr/classes/phpr_controller.php |
85 |
4 |
Phpr_Controller->_run('On404', array(0)) |
/phproad/modules/phpr/classes/phpr_response.php |
49 |
3 |
Phpr_Response->open('/brand/brands/honda') |
/phproad/system/phproad.php |
31 |
2 |
include('/home/mowerman/public_html/phproad/system/phproad.php') |
/boot.php |
114 |
1 |
require_once('/home/mowerman/public_html/boot.php') |
/index.php |
3 |