KMLINE:
,

!!!

 8-800-350-16-71 (.)

+7(495)649-17-60

 -  10:00-20:00

!!!
6932CR Bandini Classic ()
  • :
  • : Bandini
  • :
  • :
  • :
  • :

6932CR Bandini Classic ()

,
: , , -, ,
,

: 5760 .
time = 0,15604519844055
SQL_COUNT = 33
SQL_TIME = 0,12480354309082
SQL_LOG = 
memory:0,87645721435547
1 0,00016999 SET NAMES cp1251 [product]
2 0,09790182 SELECT * FROM `as_product` WHERE uri='6932cr' AND visible='yes' [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE uri='6932cr' AND visible='yes'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => visible_isLeader,visibleNovelty
    [key] => visible_isLeader
    [key_len] => 1
    [ref] => const
    [rows] => 8402
    [Extra] => Using index condition; Using where
)

3 0,00567198 SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='951' LIMIT 0,10 [product]
<b>EXPLAIN</b> SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='951' LIMIT 0,10
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product_image
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 9954
    [Extra] => Using where
)

4 0,00011492 SELECT * FROM `as_user_group_main` WHERE id = 0 [product]
<b>EXPLAIN</b> SELECT * FROM `as_user_group_main` WHERE id = 0
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => Impossible WHERE noticed after reading const tables
)

5 0,00083017 SELECT isUri FROM `as_catalog` WHERE id=66 [product]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id=66
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

6 0,00573802 
	SELECT `sp`.id as p_id, `sp`.name as p_name, `sv`.id as v_id, `sv`.name as v_name
	FROM `as_product_value` as `pv`
	LEFT JOIN `as_catalog_param` as `sp` ON `sp`.id = `pv`.filter
	LEFT JOIN `as_catalog_values` as `sv` ON `pv`.value = `sv`.id
	WHERE `pv`.product = '951' [product]
7 0,00459599 SELECT * FROM `as_product` WHERE section = 66 AND id <> 951 ORDER BY RAND() [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE section = 66 AND id <> 951 ORDER BY RAND()
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_product
    [type] => ref
    [possible_keys] => PRIMARY,section
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 16
    [Extra] => Using where; Using temporary; Using filesort
)

8 0,00036597 SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 951 LIMIT 0,2 [product]
<b>EXPLAIN</b> SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 951 LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_opinion
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 8
    [Extra] => Using where
)

9 0,00018096 SELECT FOUND_ROWS() [product]
<b>EXPLAIN</b> SELECT FOUND_ROWS()
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => No tables used
)

10 0,00088596 SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '66' [product]
<b>EXPLAIN</b> SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '66'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

11 0,0026319 SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('1', '65') ORDER BY `level` [product]
<b>EXPLAIN</b> SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('1', '65') ORDER BY `level`
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => range
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => 
    [rows] => 2
    [Extra] => Using index condition; Using filesort
)

12 0,00014591 SELECT * FROM `as_catalog_param` WHERE section = 1 [product]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_param` WHERE section = 1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_param
    [type] => ref
    [possible_keys] => section
    [key] => section
    [key_len] => 2
    [ref] => const
    [rows] => 6
    [Extra] => 
)

13 0,00017881 SELECT * FROM `as_catalog_values` WHERE filter IN('1', '2', '4', '5', '6', '7') [product]
<b>EXPLAIN</b> SELECT * FROM `as_catalog_values` WHERE filter IN('1', '2', '4', '5', '6', '7')
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_values
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 255
    [Extra] => Using where
)

14 0,00012708 SELECT isUri FROM `as_catalog` WHERE id = 1 [product]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id = 1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 4
    [ref] => const
    [rows] => 1
    [Extra] => 
)

15 0,0001452 SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'product') [_header]
<b>EXPLAIN</b> SELECT `uri`, `title`, `keywords`, `description` FROM as_seo_title WHERE `uri` IN('default', 'product')
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_title
    [type] => range
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 102
    [ref] => 
    [rows] => 2
    [Extra] => Using index condition
)

16 0,00023794 SELECT * FROM `as_static` WHERE name = ": " LIMIT 0,1 [_header]
<b>EXPLAIN</b> SELECT * FROM `as_static` WHERE name = ": " LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

17 0,00014091 SELECT email FROM `as_mail_list` WHERE header = 'yes' LIMIT 0,1 [_header]
<b>EXPLAIN</b> SELECT email FROM `as_mail_list` WHERE header = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_mail_list
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 6
    [Extra] => Using where
)

18 0,00013304 SELECT name, uri FROM `as_menu1` ORDER BY pos [_header]
<b>EXPLAIN</b> SELECT name, uri FROM `as_menu1` ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_menu1
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 7
    [Extra] => Using filesort
)

19 0,00018001 SELECT id, name, isUri, parent FROM `as_catalog` WHERE isVisible='yes' AND level < 2 ORDER BY `parent` ASC , `pos` ASC [_letf_menu]
<b>EXPLAIN</b> SELECT id, name, isUri, parent FROM `as_catalog` WHERE isVisible='yes' AND level < 2 ORDER BY `parent` ASC , `pos` ASC
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog
    [type] => ref
    [possible_keys] => isMenu_isVisible_pos,isVisible
    [key] => isVisible
    [key_len] => 1
    [ref] => const
    [rows] => 840
    [Extra] => Using index condition; Using where; Using filesort
)

20 0,00041294 SELECT id, header, notice, date FROM `as_news` WHERE visible='yes' ORDER BY date DESC LIMIT 0,2 [_letf_menu]
<b>EXPLAIN</b> SELECT id, header, notice, date FROM `as_news` WHERE visible='yes' ORDER BY date DESC LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_news
    [type] => ref
    [possible_keys] => visible_date
    [key] => visible_date
    [key_len] => 1
    [ref] => const
    [rows] => 2
    [Extra] => Using where
)

21 0,00023293 SELECT * FROM `as_biblio` WHERE visible = 'yes' ORDER BY pos [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_biblio` WHERE visible = 'yes' ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_biblio
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 4
    [Extra] => Using where; Using filesort
)

22 0,00014901 SELECT * FROM `as_menu_catalog` WHERE id='93' [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_menu_catalog` WHERE id='93'
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_menu_catalog
    [type] => const
    [possible_keys] => PRIMARY
    [key] => PRIMARY
    [key_len] => 1
    [ref] => const
    [rows] => 1
    [Extra] => 
)

23 0,00120211 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/product/6932cr/]%' ORDER BY RAND() LIMIT 0,1 [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/product/6932cr/]%' ORDER BY RAND() LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 2
    [Extra] => Using index condition; Using where; Using temporary; Using filesort
)

24 0,00076699 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[all]%' ORDER BY RAND() LIMIT 0,1 [_letf_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[all]%' ORDER BY RAND() LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 2
    [Extra] => Using index condition; Using where; Using temporary; Using filesort
)

25 0,000422 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/6932cr/]%' LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/6932cr/]%' LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 1
    [Extra] => Using index condition; Using where
)

26 0,00018692 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[all]%' ORDER BY pos LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[all]%' ORDER BY pos LIMIT 0,2
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_seo_reklama
    [type] => ref
    [possible_keys] => vis_type
    [key] => vis_type
    [key_len] => 2
    [ref] => const,const
    [rows] => 1
    [Extra] => Using index condition; Using where; Using filesort
)

27 0,00018096 SELECT id, name, uri FROM `as_catalog_brand` WHERE visible = "yes" [_right_menu]
<b>EXPLAIN</b> SELECT id, name, uri FROM `as_catalog_brand` WHERE visible = "yes"
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_catalog_brand
    [type] => ref
    [possible_keys] => visible
    [key] => visible
    [key_len] => 1
    [ref] => const
    [rows] => 59
    [Extra] => Using index condition
)

28 0,00014782 SELECT id, header, uri, date, notice, img_small FROM `as_article` WHERE visible='yes' ORDER BY date DESC LIMIT 0,1 [_right_menu]
<b>EXPLAIN</b> SELECT id, header, uri, date, notice, img_small FROM `as_article` WHERE visible='yes' ORDER BY date DESC LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_article
    [type] => system
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 1
    [Extra] => 
)

29 0,00016809 SELECT id, name FROM `as_opros` WHERE visible='yes' LIMIT 0,1 [_right_menu]
<b>EXPLAIN</b> SELECT id, name FROM `as_opros` WHERE visible='yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => 
    [type] => 
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 
    [Extra] => Impossible WHERE noticed after reading const tables
)

30 0,00013494 SELECT * FROM `as_opros_quest` WHERE category = 0 ORDER BY pos [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_opros_quest` WHERE category = 0 ORDER BY pos
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_opros_quest
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 4
    [Extra] => Using where; Using filesort
)

31 0,00014496 SELECT content FROM `as_static` WHERE name = ":  " AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = ":  " AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

32 0,0001421 SELECT content FROM `as_static` WHERE name = ": copyright" AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = ": copyright" AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

33 0,00013518 SELECT content FROM `as_static` WHERE name = ":  " AND visible = 'yes' LIMIT 0,1 [_footer]
<b>EXPLAIN</b> SELECT content FROM `as_static` WHERE name = ":  " AND visible = 'yes' LIMIT 0,1
Array
(
    [id] => 1
    [select_type] => SIMPLE
    [table] => as_static
    [type] => ALL
    [possible_keys] => 
    [key] => 
    [key_len] => 
    [ref] => 
    [rows] => 5
    [Extra] => Using where
)

memory:1,0494003295898
PHP_ERROR_LOG = 
8 Notice /home/kmline/kmline.ru/docs/_phtml/main/product/product.phtml => 18: Undefined variable: this_url [product] => [product] uri=/product/6932cr/