| file | /var/www/html/bcc/config/inc_config.php |
|---|
| line | 20 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM configuration
WHERE con_lang_id = 1
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/config/inc_config.php (Line: 20)
[1] => /var/www/html/bcc/home/config.php (Line: 30)
[2] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.00085306167602539 |
|---|
| query | SELECT *
FROM configuration
WHERE con_lang_id = 1 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/home/config.php |
|---|
| line | 53 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT city_id, city_name FROM city WHERE city_active = 1 AND city_parent_id = 0 ORDER BY FIELD(city_id, 48,32,44,1) DESC, city_id ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/home/config.php (Line: 53)
[1] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.0054869651794434 |
|---|
| query | SELECT city_id, city_name FROM city WHERE city_active = 1 AND city_parent_id = 0 ORDER BY FIELD(city_id, 48,32,44,1) DESC, city_id ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/home/config.php |
|---|
| line | 60 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM supplier ORDER BY sup_login_name ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/home/config.php (Line: 60)
[1] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.00045204162597656 |
|---|
| query | SELECT * FROM supplier ORDER BY sup_login_name ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/home/config.php |
|---|
| line | 67 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT cat_id, cat_name FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_has_child = 0 ORDER BY cat_id ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/home/config.php (Line: 67)
[1] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.00046706199645996 |
|---|
| query | SELECT cat_id, cat_name FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_has_child = 0 ORDER BY cat_id ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/home/config.php |
|---|
| line | 73 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT col_id, col_name FROM collections ORDER BY col_order ASC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/home/config.php (Line: 73)
[1] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.00041604042053223 |
|---|
| query | SELECT col_id, col_name FROM collections ORDER BY col_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/home/config.php |
|---|
| line | 80 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM user_orders LEFT JOIN products ON(uso_product_id = pro_id) WHERE pro_code IS NOT NULL ORDER BY uso_date DESC LIMIT 10
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/home/config.php (Line: 80)
[1] => /var/www/html/bcc/home/index.php (Line: 2)
)
|
|---|
| time | 0.000762939453125 |
|---|
| query | SELECT * FROM user_orders LEFT JOIN products ON(uso_product_id = pro_id) WHERE pro_code IS NOT NULL ORDER BY uso_date DESC LIMIT 10 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2351 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 0 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2351)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00058388710021973 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 0 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 1 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00042891502380371 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 1 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 3 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00042915344238281 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 3 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 6 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.0004119873046875 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 6 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 8 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00039887428283691 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 8 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 5 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00038504600524902 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 5 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 9 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 163)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00040006637573242 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 9 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2351 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 0 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2351)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00048685073852539 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 0 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 1 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00046300888061523 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 1 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 3 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00044798851013184 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 3 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 6 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00040102005004883 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 6 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 8 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00044608116149902 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 8 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 5 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00047016143798828 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 5 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 2361 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 9 ORDER BY mnu_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 2361)
[1] => /var/www/html/bcc/includes/inc_header.php (Line: 177)
[2] => /var/www/html/bcc/home/index.php (Line: 52)
)
|
|---|
| time | 0.00042510032653809 |
|---|
| query | SELECT * FROM menus WHERE mnu_type = 1 AND mnu_active = 1 AND mnu_parent_id = 9 ORDER BY mnu_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(1) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 3)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00049304962158203 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(1) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_form_filter.php |
|---|
| line | 46 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_has_child = 1 AND cat_type = 'product' ORDER BY cat_id ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_form_filter.php (Line: 46)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 21)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00046610832214355 |
|---|
| query | SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_has_child = 1 AND cat_type = 'product' ORDER BY cat_id ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_form_filter.php |
|---|
| line | 48 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_parent_id = 7 ORDER BY cat_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_form_filter.php (Line: 48)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 21)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00053501129150391 |
|---|
| query | SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_parent_id = 7 ORDER BY cat_order ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 155 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_active = 1 AND pro_hot = 1 ORDER BY pro_id DESC LIMIT 0,20
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 155)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 28)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00082087516784668 |
|---|
| query | SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_active = 1 AND pro_hot = 1 ORDER BY pro_id DESC LIMIT 0,20 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 155 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id = 1 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 155)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 141)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00074386596679688 |
|---|
| query | SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id = 1 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(9) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 149)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00054812431335449 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(9) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 155 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id = 44 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 155)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 165)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00072383880615234 |
|---|
| query | SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id = 44 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(10) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 173)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00045895576477051 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(10) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 155 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id <> 1 AND pro_city_id <> 44 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 155)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 190)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00091195106506348 |
|---|
| query | SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
LEFT JOIN supplier_product on (spp_product_id = pro_id AND spp_status = 1)
WHERE spp_is_sold != 1 AND pro_city_id <> 1 AND pro_city_id <> 44 AND pro_active = 1 ORDER BY pro_date DESC LIMIT 0,20 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(11) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 198)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00058388710021973 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(11) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 155 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
WHERE 1 AND pro_active = 0 ORDER BY pro_id DESC LIMIT 0,40
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 155)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 214)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.19115209579468 |
|---|
| query | SELECT pro_id,pro_name,pro_city_id,pro_category_id,pro_code,sup_id,sup_name,pro_active,pro_price,pro_sale_prices
FROM products
STRAIGHT_JOIN categories_multi ON(cat_id = pro_category_id)
LEFT JOIN supplier on (sup_id = pro_supplier_id)
WHERE 1 AND pro_active = 0 ORDER BY pro_id DESC LIMIT 0,40 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(5) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_filter_bar.php (Line: 72)
[2] => /var/www/html/bcc/includes/inc_home.php (Line: 230)
[3] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00060892105102539 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(5) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/functions/function_website.php |
|---|
| line | 40 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | SLAVE |
|---|
| args | Array
(
[0] => SELECT *
FROM banners
WHERE 1 AND ban_position IN(6) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC
[1] => USE_SLAVE
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/functions/function_website.php (Line: 40)
[1] => /var/www/html/bcc/includes/inc_filter_bar.php (Line: 84)
[2] => /var/www/html/bcc/includes/inc_home.php (Line: 230)
[3] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.0004420280456543 |
|---|
| query | SELECT *
FROM banners
WHERE 1 AND ban_position IN(6) AND ban_active = 1
ORDER BY ban_order ASC, ban_id DESC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_filter_bar.php |
|---|
| line | 100 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT new_id, new_picture, new_title, new_date, new_teaser FROM news_multi WHERE new_active = 1 AND new_hot = 1 ORDER BY new_id DESC LIMIT 3
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_filter_bar.php (Line: 100)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 230)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00085186958312988 |
|---|
| query | SELECT new_id, new_picture, new_title, new_date, new_teaser FROM news_multi WHERE new_active = 1 AND new_hot = 1 ORDER BY new_id DESC LIMIT 3 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_layout_news.php |
|---|
| line | 5 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT new_id, new_picture, new_title, new_date, new_teaser FROM news_multi WHERE new_active = 1 AND new_hot = 1 ORDER BY new_id DESC LIMIT 5
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_layout_news.php (Line: 5)
[1] => /var/www/html/bcc/includes/inc_home.php (Line: 235)
[2] => /var/www/html/bcc/home/index.php (Line: 53)
)
|
|---|
| time | 0.00075197219848633 |
|---|
| query | SELECT new_id, new_picture, new_title, new_date, new_teaser FROM news_multi WHERE new_active = 1 AND new_hot = 1 ORDER BY new_id DESC LIMIT 5 |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_footer.php |
|---|
| line | 275 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_has_child = 1 AND cat_type = 'product' ORDER BY cat_id ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_footer.php (Line: 275)
[1] => /var/www/html/bcc/home/index.php (Line: 54)
)
|
|---|
| time | 0.00049710273742676 |
|---|
| query | SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_has_child = 1 AND cat_type = 'product' ORDER BY cat_id ASC |
|---|
| host | localhost |
|---|
|
| file | /var/www/html/bcc/includes/inc_footer.php |
|---|
| line | 277 |
|---|
| function | __construct |
|---|
| class | db_query |
|---|
| type | MASTER |
|---|
| args | Array
(
[0] => SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_parent_id = 7 ORDER BY cat_order ASC
)
|
|---|
| listfile | Array
(
[0] => /var/www/html/bcc/includes/inc_footer.php (Line: 277)
[1] => /var/www/html/bcc/home/index.php (Line: 54)
)
|
|---|
| time | 0.00061392784118652 |
|---|
| query | SELECT * FROM categories_multi WHERE cat_active = 1 AND cat_type = 'product' AND cat_parent_id = 7 ORDER BY cat_order ASC |
|---|
| host | localhost |
|---|
|
ĐĂNG BÁN BIỂN
CỘNG TÁC VIÊN
TRAO ĐỔI XNB
![[Cập nhật 2024] Biển số xe các tỉnh thành phố tại Việt Nam](/data/new/ytm1719455898.jpg)
Chat Zalo
1900088887