KMLINE:
,

!!!

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

+7(495)649-17-60

 -  10:00-20:00

!!!
60 . Hayta Classic Gold 13909-GOLD
  • :
  • : Hayta
  • :
  • :
  • :
  • :

60 . Hayta Classic Gold 13909-GOLD

: 5880 .
time = 0,0695481300354
SQL_COUNT = 33
SQL_TIME = 0,049300909042358
SQL_LOG = 
memory:0,87646484375
1 0,00010109 SET NAMES cp1251 [product]
2 0,03335404 SELECT * FROM `as_product` WHERE uri='polka_13909-gold' AND visible='yes' [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE uri='polka_13909-gold' 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,00442815 SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='359' LIMIT 0,10 [product]
<b>EXPLAIN</b> SELECT id, name, img, img_main, img_med, img_small FROM `as_product_image` WHERE product='359' 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,00011396 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,00055003 SELECT isUri FROM `as_catalog` WHERE id=46 [product]
<b>EXPLAIN</b> SELECT isUri FROM `as_catalog` WHERE id=46
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,0015471 
	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 = '359' [product]
7 0,002671 SELECT * FROM `as_product` WHERE section = 46 AND id <> 359 ORDER BY RAND() [product]
<b>EXPLAIN</b> SELECT * FROM `as_product` WHERE section = 46 AND id <> 359 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] => 19
    [Extra] => Using where; Using temporary; Using filesort
)

8 0,00057912 SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 359 LIMIT 0,2 [product]
<b>EXPLAIN</b> SELECT SQL_CALC_FOUND_ROWS * FROM `as_opinion` WHERE status = 'pub' AND product = 359 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,00012994 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,00022411 SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '46' [product]
<b>EXPLAIN</b> SELECT id,name, path, isUri FROM `as_catalog` WHERE id = '46'
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,00040913 SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('1', '22') ORDER BY `level` [product]
<b>EXPLAIN</b> SELECT id, name, isUri, isProduct FROM `as_catalog` WHERE id IN('1', '22') 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,00048399 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,00015402 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,00011992 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,00012493 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,00011301 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,0001092 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,00021791 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,00014901 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,00011802 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,00014091 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,00010991 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,00117421 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'left' AND uri LIKE '%[/product/polka_13909-gold/]%' 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/polka_13909-gold/]%' 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,00066018 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,00042915 SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/polka_13909-gold/]%' LIMIT 0,2 [_right_menu]
<b>EXPLAIN</b> SELECT * FROM `as_seo_reklama` WHERE visible = 'yes' AND type = 'right' AND uri LIKE '%[/product/polka_13909-gold/]%' 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,00012279 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,00021195 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,00013089 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,00015402 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,00013304 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,00013208 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,00012612 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 7,796E-5 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,0494079589844
PHP_ERROR_LOG = 
8 Notice /home/kmline/kmline.ru/docs/_phtml/main/product/product.phtml => 18: Undefined variable: this_url [product] => [product] uri=/product/polka_13909-gold/