Общий отчет
(Время: 1.57702с,
Память: 10,411Кб)
|
| Процедура |
Номер |
Всего (с) |
Средн. (с) |
Мин. (с) |
Макс. (с) |
system.db.CDbCommand.query(SELECT `t1`.`product_id`
FROM `StoreProductLastVisited` `t1`
JOIN `StoreProductLastVisited` `t2` ON t1.hash=t2.hash
WHERE t1.product_id != t2.product_id AND t2.product_id=:product_id LIMIT 20. Bound with :product_id=’12568′) |
1 |
0.44971 |
0.44971 |
0.44971 |
0.44971 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`retail_price` AS `t0_c6`, `t`.`max_price` AS `t0_c7`, `t`.`is_active` AS `t0_c8`, `t`.`layout` AS `t0_c9`, `t`.`view` AS `t0_c10`, `t`.`sku` AS `t0_c11`, `t`.`quantity` AS `t0_c12`, `t`.`availability` AS `t0_c13`, `t`.`auto_decrease_quantity` AS `t0_c14`, `t`.`views_count` AS `t0_c15`, `t`.`created` AS `t0_c16`, `t`.`updated` AS `t0_c17`, `t`.`added_to_cart_count` AS `t0_c18`, `t`.`votes` AS `t0_c19`, `t`.`rating` AS `t0_c20`, `t`.`novelty` AS `t0_c21`, `t`.`top` AS `t0_c22`, `t`.`sale` AS `t0_c23`, `t`.`market` AS `t0_c24`, `t`.`buy_one_click` AS `t0_c25`, `t`.`position` AS `t0_c26`, `domainData`.`id` AS `t1_c0`, `domainData`.`product_id` AS `t1_c1`, `domainData`.`domain_id` AS `t1_c2`, `domainData`.`price` AS `t1_c3`, `type`.`id` AS `t2_c0`, `type`.`name` AS `t2_c1`, `type`.`categories_preset` AS `t2_c2`, `type`.`main_category` AS `t2_c3`, `translate`.`id` AS `t3_c0`, `translate`.`object_id` AS `t3_c1`, `translate`.`language_id` AS `t3_c2`, `translate`.`name` AS `t3_c3`, `translate`.`fullname` AS `t3_c4`, `translate`.`short_description` AS `t3_c5`, `translate`.`full_description` AS `t3_c6`, `translate`.`meta_title` AS `t3_c7`, `translate`.`meta_keywords` AS `t3_c8`, `translate`.`meta_description` AS `t3_c9` FROM `StoreProduct` `t` INNER JOIN StoreProductLastVisited visited ON t.id=visited.product_id LEFT OUTER JOIN `StoreProductDomain` `domainData` ON (`domainData`.`product_id`=`t`.`id`) AND (domainData.domain_id=:domain_id) LEFT OUTER JOIN `StoreProductType` `type` ON (`t`.`type_id`=`type`.`id`) LEFT OUTER JOIN `StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) WHERE (((visited.hash=:hash) AND (visited.product_id != :product_id)) AND (`t`.is_active=1 AND (`t`.price>0 OR use_configurations=1 OR `t`.availability=2))) AND (translate.language_id=:language_id) GROUP BY t.id ORDER BY lastvisited DESC LIMIT 20. Bound with :hash=’b6978634db7cd931b12315246572154f’, :product_id=’12568′, :domain_id=’171′, :language_id=’1′) |
1 |
0.28879 |
0.28879 |
0.28879 |
0.28879 |
| fetchLocation |
1 |
0.07929 |
0.07929 |
0.07929 |
0.07929 |
| system.db.CDbCommand.query(SELECT * FROM `StoreProductLastVisited` `t` WHERE `t`.`product_id`=:yp0 AND `t`.`hash`=:yp1 LIMIT 1. Bound with :yp0=’12568′, :yp1=’b6978634db7cd931b12315246572154f’) |
1 |
0.04008 |
0.04008 |
0.04008 |
0.04008 |
| renderMenu |
1 |
0.03386 |
0.03386 |
0.03386 |
0.03386 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’6685′, :language_id=’1′) |
1 |
0.01794 |
0.01794 |
0.01794 |
0.01794 |
| renderHeader |
1 |
0.01518 |
0.01518 |
0.01518 |
0.01518 |
system.db.CDbCommand.query(SELECT *
FROM `AuthAssignment`
WHERE userid=:userid. Bound with :userid=NULL) |
3 |
0.01395 |
0.00465 |
0.00010 |
0.01024 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75499′, :language_id=’1′) |
1 |
0.01126 |
0.01126 |
0.01126 |
0.01126 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75518′) |
1 |
0.01080 |
0.01080 |
0.01080 |
0.01080 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75455′, :language_id=’1′) |
1 |
0.01050 |
0.01050 |
0.01050 |
0.01050 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’77222′, :language_id=’1′) |
1 |
0.01026 |
0.01026 |
0.01026 |
0.01026 |
| system.db.CDbCommand.query(SELECT `imagesNoMain`.`id` AS `t1_c0`, `imagesNoMain`.`product_id` AS `t1_c1`, `imagesNoMain`.`name` AS `t1_c2`, `imagesNoMain`.`is_main` AS `t1_c3`, `imagesNoMain`.`uploaded_by` AS `t1_c4`, `imagesNoMain`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `imagesNoMain` WHERE (imagesNoMain.is_main=0) AND (`imagesNoMain`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’12568′) |
1 |
0.00963 |
0.00963 |
0.00963 |
0.00963 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductAttributeEAV`) |
1 |
0.00714 |
0.00714 |
0.00714 |
0.00714 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductImage`) |
1 |
0.00430 |
0.00430 |
0.00430 |
0.00430 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreManufacturerTranslate`) |
1 |
0.00428 |
0.00428 |
0.00428 |
0.00428 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreDeliveryRole`) |
1 |
0.00418 |
0.00418 |
0.00418 |
0.00418 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`retail_price` AS `t0_c6`, `t`.`max_price` AS `t0_c7`, `t`.`is_active` AS `t0_c8`, `t`.`layout` AS `t0_c9`, `t`.`view` AS `t0_c10`, `t`.`sku` AS `t0_c11`, `t`.`quantity` AS `t0_c12`, `t`.`availability` AS `t0_c13`, `t`.`auto_decrease_quantity` AS `t0_c14`, `t`.`views_count` AS `t0_c15`, `t`.`created` AS `t0_c16`, `t`.`updated` AS `t0_c17`, `t`.`added_to_cart_count` AS `t0_c18`, `t`.`votes` AS `t0_c19`, `t`.`rating` AS `t0_c20`, `t`.`novelty` AS `t0_c21`, `t`.`top` AS `t0_c22`, `t`.`sale` AS `t0_c23`, `t`.`market` AS `t0_c24`, `t`.`buy_one_click` AS `t0_c25`, `t`.`position` AS `t0_c26`, `domainData`.`id` AS `t1_c0`, `domainData`.`product_id` AS `t1_c1`, `domainData`.`domain_id` AS `t1_c2`, `domainData`.`price` AS `t1_c3`, `type`.`id` AS `t2_c0`, `type`.`name` AS `t2_c1`, `type`.`categories_preset` AS `t2_c2`, `type`.`main_category` AS `t2_c3`, `translate`.`id` AS `t3_c0`, `translate`.`object_id` AS `t3_c1`, `translate`.`language_id` AS `t3_c2`, `translate`.`name` AS `t3_c3`, `translate`.`fullname` AS `t3_c4`, `translate`.`short_description` AS `t3_c5`, `translate`.`full_description` AS `t3_c6`, `translate`.`meta_title` AS `t3_c7`, `translate`.`meta_keywords` AS `t3_c8`, `translate`.`meta_description` AS `t3_c9` FROM `StoreProduct` `t` LEFT OUTER JOIN `StoreProductDomain` `domainData` ON (`domainData`.`product_id`=`t`.`id`) AND (domainData.domain_id=:domain_id) LEFT OUTER JOIN `StoreProductType` `type` ON (`t`.`type_id`=`type`.`id`) LEFT OUTER JOIN `StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) WHERE ((t.id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17, :ycp18, :ycp19)) AND (`t`.is_active=1 AND (`t`.price>0 OR use_configurations=1 OR `t`.availability=2))) AND (translate.language_id=:language_id) ORDER BY FIELD(t.id, 17396, 75453, 75455, 17401, 67782, 75468, 75499, 17667, 75500, 6669, 6685, 75518, 75516, 77893, 75524, 77218, 77220, 77222, 77224, 17411). Bound with :ycp0=’17396′, :ycp1=’75453′, :ycp2=’75455′, :ycp3=’17401′, :ycp4=’67782′, :ycp5=’75468′, :ycp6=’75499′, :ycp7=’17667′, :ycp8=’75500′, :ycp9=’6669′, :ycp10=’6685′, :ycp11=’75518′, :ycp12=’75516′, :ycp13=’77893′, :ycp14=’75524′, :ycp15=’77218′, :ycp16=’77220′, :ycp17=’77222′, :ycp18=’77224′, :ycp19=’17411′, :domain_id=’171′, :language_id=’1′) |
1 |
0.00306 |
0.00306 |
0.00306 |
0.00306 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductLastVisited`) |
1 |
0.00288 |
0.00288 |
0.00288 |
0.00288 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’77222′) |
1 |
0.00272 |
0.00272 |
0.00272 |
0.00272 |
| renderBlock |
2 |
0.00259 |
0.00130 |
0.00098 |
0.00161 |
| InitSystemSettings |
1 |
0.00242 |
0.00242 |
0.00242 |
0.00242 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `Discount`) |
1 |
0.00223 |
0.00223 |
0.00223 |
0.00223 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductDeliveryMethod`) |
1 |
0.00187 |
0.00187 |
0.00187 |
0.00187 |
| system.db.CDbCommand.query(SELECT `deliveryMethods`.`id` AS `t1_c0`, `deliveryMethods`.`price` AS `t1_c1`, `deliveryMethods`.`price_for_product` AS `t1_c2`, `deliveryMethods`.`free_from` AS `t1_c3`, `deliveryMethods`.`time_begin` AS `t1_c4`, `deliveryMethods`.`time_end` AS `t1_c5`, `deliveryMethods`.`duration` AS `t1_c6`, `deliveryMethods`.`delivery_system` AS `t1_c7`, `deliveryMethods`.`position` AS `t1_c8`, `deliveryMethods`.`active` AS `t1_c9`, `deliveryMethods`.`show_in_short_block` AS `t1_c10`, `dm_translate`.`id` AS `t3_c0`, `dm_translate`.`object_id` AS `t3_c1`, `dm_translate`.`language_id` AS `t3_c2`, `dm_translate`.`name` AS `t3_c3`, `dm_translate`.`short_name` AS `t3_c4`, `dm_translate`.`name_in_block` AS `t3_c5`, `dm_translate`.`description` AS `t3_c6` FROM `StoreDeliveryMethod` `deliveryMethods` LEFT OUTER JOIN `StoreProductDeliveryMethod` `product_deliveryMethods` ON (`product_deliveryMethods`.`delivery_id`=`deliveryMethods`.`id`) LEFT OUTER JOIN `StoreDeliveryMethodTranslate` `dm_translate` ON (`dm_translate`.`object_id`=`deliveryMethods`.`id`) WHERE (active=1) AND (`product_deliveryMethods`.`product_id`=:ypl0) AND (dm_translate.language_id=:language_id) ORDER BY position. Bound with :ypl0=’12568′, :language_id=’1′) |
1 |
0.00166 |
0.00166 |
0.00166 |
0.00166 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Order`) |
1 |
0.00129 |
0.00129 |
0.00129 |
0.00129 |
| system.db.CDbCommand.query(SELECT * FROM `StoreProductAttributeEAV` `t` WHERE entity = 12568) |
1 |
0.00125 |
0.00125 |
0.00125 |
0.00125 |
| system.db.CDbCommand.query(SELECT * FROM `rCity` `t` WHERE `t`.`region_id`=:yp0 AND `t`.`id` IN (3110, 2689, 747, 2355, 2697, 71, 2686, 2973, 1607, 349, 1509, 938, 1895, 1356, 745, 663, 1357, 2610, 34, 3453, 70, 415, 2357, 3909, 541, 2970, 2213, 3389, 1117, 743, 1118, 1167, 1207, 3771, 2698, 1450, 2495, 3446, 1932, 1915, 3206, 2358, 2242, 3733, 1513, 2149, 3539, 4028, 69, 1870, 2352, 3581, 3208, 1510, 216, 2241, 1931, 1471, 2409, 1898, 490, 1913, 2683, 1507, 3449, 3131, 3732, 1586, 218, 1514, 517, 1894, 141, 2896, 4059, 220, 143, 2243, 1512, 2147, 2575, 1892, 2353, 1516, 1778, 2972, 2240, 3054, 1665, 1469, 1468, 2354, 3445, 3207, 215, 2685, 3157, 2918, 744, 3371, 1903, 3370, 1472, 3582, 1899, 278, 3882, 574, 575, 620, 662, 1830, 2563, 1891, 217, 3908, 1908, 2239, 740, 1358, 1277, 846, 1664, 884, 2447, 4238, 937, 4270, 1608, 3344, 1900, 4271, 2690, 3936, 3774, 2684, 2238, 378, 1663, 1467, 886, 3687, 741, 993, 3970, 2696, 314, 885, 3343, 2692, 1022, 75, 313, 1309, 1078, 73, 2971, 72, 76, 1662, 3688, 2407, 1470, 2159, 2917, 140, 1166, 4208, 2623, 742, 4194, 939, 1, 3053, 1276) ORDER BY t.population ASC LIMIT 1. Bound with :yp0=») |
1 |
0.00123 |
0.00123 |
0.00123 |
0.00123 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `SystemModules`) |
1 |
0.00120 |
0.00120 |
0.00120 |
0.00120 |
| system.db.CDbCommand.query(SELECT * FROM `rCity` `t` WHERE `t`.`region_id`=:yp0 AND `t`.`id` IN (3110, 1607, 349, 1356, 377, 1357, 2610, 34, 70, 415, 541, 2970, 2213, 3389, 1117, 743, 1118, 1167, 1207, 3771, 2495, 1932, 1915, 3206, 3539, 4028, 69, 1870, 2352, 3581, 216, 2409, 490, 2683, 1507, 3732, 517, 141, 4059, 2575, 2353, 1778, 2972, 3054, 3445, 3207, 215, 2685, 3157, 3371, 1903, 3370, 278, 3882, 574, 575, 620, 662, 1830, 2563, 3908, 2239, 740, 1358, 846, 884, 2447, 4238, 937, 1608, 3344, 1900, 3936, 2684, 2238, 378, 1663, 1467, 3687, 993, 3970, 885, 3343, 1022, 313, 1309, 1078, 2971, 1662, 3688, 2407, 2917, 140, 1166, 2623, 742, 4194, 1, 3053, 1276) ORDER BY t.population ASC LIMIT 1. Bound with :yp0=») |
1 |
0.00119 |
0.00119 |
0.00119 |
0.00119 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’19’) |
1 |
0.00117 |
0.00117 |
0.00117 |
0.00117 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProduct`) |
1 |
0.00113 |
0.00113 |
0.00113 |
0.00113 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreCategory`) |
1 |
0.00105 |
0.00105 |
0.00105 |
0.00105 |
| ImageGetUrl |
23 |
0.00103 |
0.00004 |
0.00001 |
0.00057 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreDeliveryMethod`) |
1 |
0.00102 |
0.00102 |
0.00102 |
0.00102 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Predicate`) |
1 |
0.00096 |
0.00096 |
0.00096 |
0.00096 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `rCity`) |
1 |
0.00095 |
0.00095 |
0.00095 |
0.00095 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Vacancy`) |
1 |
0.00093 |
0.00093 |
0.00093 |
0.00093 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `SystemLanguage`) |
1 |
0.00092 |
0.00092 |
0.00092 |
0.00092 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Discount`) |
1 |
0.00092 |
0.00092 |
0.00092 |
0.00092 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreCurrency`) |
1 |
0.00088 |
0.00088 |
0.00088 |
0.00088 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `rDomain`) |
1 |
0.00084 |
0.00084 |
0.00084 |
0.00084 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’12568′) |
1 |
0.00084 |
0.00084 |
0.00084 |
0.00084 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`retail_price` AS `t0_c6`, `t`.`max_price` AS `t0_c7`, `t`.`is_active` AS `t0_c8`, `t`.`layout` AS `t0_c9`, `t`.`view` AS `t0_c10`, `t`.`sku` AS `t0_c11`, `t`.`quantity` AS `t0_c12`, `t`.`availability` AS `t0_c13`, `t`.`auto_decrease_quantity` AS `t0_c14`, `t`.`views_count` AS `t0_c15`, `t`.`created` AS `t0_c16`, `t`.`updated` AS `t0_c17`, `t`.`added_to_cart_count` AS `t0_c18`, `t`.`votes` AS `t0_c19`, `t`.`rating` AS `t0_c20`, `t`.`novelty` AS `t0_c21`, `t`.`top` AS `t0_c22`, `t`.`sale` AS `t0_c23`, `t`.`market` AS `t0_c24`, `t`.`buy_one_click` AS `t0_c25`, `t`.`position` AS `t0_c26`, `domainData`.`id` AS `t1_c0`, `domainData`.`product_id` AS `t1_c1`, `domainData`.`domain_id` AS `t1_c2`, `domainData`.`price` AS `t1_c3`, `translate`.`id` AS `t2_c0`, `translate`.`object_id` AS `t2_c1`, `translate`.`language_id` AS `t2_c2`, `translate`.`name` AS `t2_c3`, `translate`.`fullname` AS `t2_c4`, `translate`.`short_description` AS `t2_c5`, `translate`.`full_description` AS `t2_c6`, `translate`.`meta_title` AS `t2_c7`, `translate`.`meta_keywords` AS `t2_c8`, `translate`.`meta_description` AS `t2_c9` FROM `StoreProduct` `t` LEFT OUTER JOIN `StoreProductDomain` `domainData` ON (`domainData`.`product_id`=`t`.`id`) AND (domainData.domain_id=:domain_id) LEFT OUTER JOIN `StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) WHERE ((`t`.is_active=1 AND (`t`.price>0 OR use_configurations=1 OR `t`.availability=2)) AND (url=:url)) AND (translate.language_id=:language_id). Bound with :url=’datchik-saturn-mms-1.php’, :domain_id=’171′, :language_id=’1′) |
1 |
0.00080 |
0.00080 |
0.00080 |
0.00080 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `Block`) |
1 |
0.00080 |
0.00080 |
0.00080 |
0.00080 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductTranslate`) |
1 |
0.00079 |
0.00079 |
0.00079 |
0.00079 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreCategoryTranslate`) |
1 |
0.00072 |
0.00072 |
0.00072 |
0.00072 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `rRegion`) |
1 |
0.00068 |
0.00068 |
0.00068 |
0.00068 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreRelatedProduct`) |
1 |
0.00067 |
0.00067 |
0.00067 |
0.00067 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductCategoryRef`) |
1 |
0.00067 |
0.00067 |
0.00067 |
0.00067 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreDeliveryMethodTranslate`) |
1 |
0.00065 |
0.00065 |
0.00065 |
0.00065 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductDomain`) |
1 |
0.00065 |
0.00065 |
0.00065 |
0.00065 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreManufacturer`) |
1 |
0.00064 |
0.00064 |
0.00064 |
0.00064 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `StoreProductType`) |
1 |
0.00063 |
0.00063 |
0.00063 |
0.00063 |
| system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `rCountry`) |
1 |
0.00062 |
0.00062 |
0.00062 |
0.00062 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`manufacturer_id` AS `t0_c1`, `t`.`type_id` AS `t0_c2`, `t`.`use_configurations` AS `t0_c3`, `t`.`url` AS `t0_c4`, `t`.`price` AS `t0_c5`, `t`.`retail_price` AS `t0_c6`, `t`.`max_price` AS `t0_c7`, `t`.`is_active` AS `t0_c8`, `t`.`layout` AS `t0_c9`, `t`.`view` AS `t0_c10`, `t`.`sku` AS `t0_c11`, `t`.`quantity` AS `t0_c12`, `t`.`availability` AS `t0_c13`, `t`.`auto_decrease_quantity` AS `t0_c14`, `t`.`views_count` AS `t0_c15`, `t`.`created` AS `t0_c16`, `t`.`updated` AS `t0_c17`, `t`.`added_to_cart_count` AS `t0_c18`, `t`.`votes` AS `t0_c19`, `t`.`rating` AS `t0_c20`, `t`.`novelty` AS `t0_c21`, `t`.`top` AS `t0_c22`, `t`.`sale` AS `t0_c23`, `t`.`market` AS `t0_c24`, `t`.`buy_one_click` AS `t0_c25`, `t`.`position` AS `t0_c26`, `translate`.`id` AS `t1_c0`, `translate`.`object_id` AS `t1_c1`, `translate`.`language_id` AS `t1_c2`, `translate`.`name` AS `t1_c3`, `translate`.`fullname` AS `t1_c4`, `translate`.`short_description` AS `t1_c5`, `translate`.`full_description` AS `t1_c6`, `translate`.`meta_title` AS `t1_c7`, `translate`.`meta_keywords` AS `t1_c8`, `translate`.`meta_description` AS `t1_c9` FROM `StoreProduct` `t` LEFT OUTER JOIN `StoreProductTranslate` `translate` ON (`translate`.`object_id`=`t`.`id`) WHERE (url=:url) AND (translate.language_id=:language_id). Bound with :url=’datchik-saturn-mms-1.php’, :language_id=’1′) |
1 |
0.00062 |
0.00062 |
0.00062 |
0.00062 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’12568′, :language_id=’1′) |
1 |
0.00061 |
0.00061 |
0.00061 |
0.00061 |
| system.db.CDbCommand.query(SELECT `product_id` AS `c`, COUNT(*) AS `s` FROM `StoreRelatedProduct` `t` WHERE (`t`.`product_id`=12568) GROUP BY `product_id`) |
1 |
0.00059 |
0.00059 |
0.00059 |
0.00059 |
| renderRegion |
1 |
0.00058 |
0.00058 |
0.00058 |
0.00058 |
| createStoreUrl |
49 |
0.00057 |
0.00001 |
0.00001 |
0.00004 |
| system.db.CDbCommand.query(SELECT * FROM `Vacancy` `t` WHERE region_id = 0 OR region_id=:region_id ORDER BY region_id LIMIT 1. Bound with :region_id=») |
1 |
0.00057 |
0.00057 |
0.00057 |
0.00057 |
| system.db.CDbCommand.execute(INSERT INTO `StoreProductLastVisited` (`hash`, `product_id`, `lastvisited`) VALUES (:yp0, :yp1, :yp2). Bound with :yp0=’b6978634db7cd931b12315246572154f’, :yp1=12568, :yp2=’2023-04-23 08:30:23′) |
1 |
0.00055 |
0.00055 |
0.00055 |
0.00055 |
| system.db.CDbCommand.query(SELECT * FROM `Discount` `t` WHERE ((t.active=1) AND (t.type=:type)) AND ((start_date IS NULL OR start_date <= :now) AND (end_date IS NULL OR end_date >= :now)). Bound with :type=1, :now=’2023-04-23 08:30:23′) |
1 |
0.00041 |
0.00041 |
0.00041 |
0.00041 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’77218′) |
1 |
0.00023 |
0.00023 |
0.00023 |
0.00023 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’77218′, :language_id=’1′) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’17411′) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’77220′, :language_id=’1′) |
1 |
0.00021 |
0.00021 |
0.00021 |
0.00021 |
| system.db.CDbCommand.query(SELECT name FROM `SystemModules` `t` WHERE enabled=1) |
1 |
0.00019 |
0.00019 |
0.00019 |
0.00019 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `Order`) |
1 |
0.00018 |
0.00018 |
0.00018 |
0.00018 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’77220′) |
1 |
0.00018 |
0.00018 |
0.00018 |
0.00018 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’77224′, :language_id=’1′) |
1 |
0.00018 |
0.00018 |
0.00018 |
0.00018 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75518′, :language_id=’1′) |
1 |
0.00018 |
0.00018 |
0.00018 |
0.00018 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductAttributeEAV`) |
1 |
0.00017 |
0.00017 |
0.00017 |
0.00017 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75500′, :language_id=’1′) |
1 |
0.00017 |
0.00017 |
0.00017 |
0.00017 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreDeliveryRole`) |
1 |
0.00017 |
0.00017 |
0.00017 |
0.00017 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `Predicate`) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’18’) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
system.db.CDbCommand.query(SELECT name,t1.type,description,t1.bizrule,t1.data,weight
FROM AuthItem t1
LEFT JOIN Rights t2 ON name=itemname
ORDER BY t1.type DESC, weight ASC) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’17401′, :language_id=’1′) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75516′, :language_id=’1′) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreDeliveryMethod`) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SELECT * FROM `Block` `t` WHERE `t`.`region`=:yp0 ORDER BY region ASC, position ASC. Bound with :yp0=’sub_search_without_main’) |
1 |
0.00016 |
0.00016 |
0.00016 |
0.00016 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreCategory`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’17396′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `SystemModules`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `rDomain`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’77893′, :language_id=’1′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProduct`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’17401′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `Vacancy`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductImage`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductDeliveryMethod`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’17667′, :language_id=’1′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75524′, :language_id=’1′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’17396′, :language_id=’1′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `rCity`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75453′, :language_id=’1′) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreManufacturer`) |
1 |
0.00015 |
0.00015 |
0.00015 |
0.00015 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’75468′, :language_id=’1′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductLastVisited`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’17667′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `Block`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreCategoryTranslate`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `manufacturer`.`id` AS `t1_c0`, `manufacturer`.`url` AS `t1_c1`, `manufacturer`.`layout` AS `t1_c2`, `manufacturer`.`view` AS `t1_c3`, `man_translate`.`id` AS `t2_c0`, `man_translate`.`object_id` AS `t2_c1`, `man_translate`.`language_id` AS `t2_c2`, `man_translate`.`name` AS `t2_c3`, `man_translate`.`altname` AS `t2_c4`, `man_translate`.`altname2` AS `t2_c5`, `man_translate`.`description` AS `t2_c6`, `man_translate`.`meta_title` AS `t2_c7`, `man_translate`.`meta_keywords` AS `t2_c8`, `man_translate`.`meta_description` AS `t2_c9` FROM `StoreManufacturer` `manufacturer` LEFT OUTER JOIN `StoreManufacturerTranslate` `man_translate` ON (`man_translate`.`object_id`=`manufacturer`.`id`) WHERE (`manufacturer`.`id`=:ypl0) AND (man_translate.language_id=:language_id). Bound with :ypl0=’514′, :language_id=’1′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT name FROM `SystemModules` `t`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreManufacturerTranslate`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreCurrency`) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’67782′, :language_id=’1′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’6669′, :language_id=’1′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’77224′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SELECT `mainCategory`.`id` AS `t1_c0`, `mainCategory`.`lft` AS `t1_c1`, `mainCategory`.`rgt` AS `t1_c2`, `mainCategory`.`level` AS `t1_c3`, `mainCategory`.`exclude_from_list` AS `t1_c4`, `mainCategory`.`show_fullname_product` AS `t1_c5`, `mainCategory`.`url` AS `t1_c6`, `mainCategory`.`full_path` AS `t1_c7`, `mainCategory`.`layout` AS `t1_c8`, `mainCategory`.`view` AS `t1_c9`, `cat_translate`.`id` AS `t3_c0`, `cat_translate`.`object_id` AS `t3_c1`, `cat_translate`.`language_id` AS `t3_c2`, `cat_translate`.`name` AS `t3_c3`, `cat_translate`.`fullname` AS `t3_c4`, `cat_translate`.`description` AS `t3_c5`, `cat_translate`.`meta_title` AS `t3_c6`, `cat_translate`.`meta_keywords` AS `t3_c7`, `cat_translate`.`meta_description` AS `t3_c8`, `cat_translate`.`tmp` AS `t3_c9` FROM `StoreCategory` `mainCategory` LEFT OUTER JOIN `StoreProductCategoryRef` `categorization` ON (`categorization`.`category`=`mainCategory`.`id`) LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`mainCategory`.`id`) WHERE (categorization.is_main = 1) AND (`categorization`.`product`=:ypl0) AND (cat_translate.language_id=:language_id). Bound with :ypl0=’17411′, :language_id=’1′) |
1 |
0.00014 |
0.00014 |
0.00014 |
0.00014 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductType`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `SystemLanguage`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75500′) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductCategoryRef`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreDeliveryMethodTranslate`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `rRegion`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreRelatedProduct`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `rCountry`) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`lft` AS `t0_c1`, `t`.`rgt` AS `t0_c2`, `t`.`level` AS `t0_c3`, `t`.`exclude_from_list` AS `t0_c4`, `t`.`show_fullname_product` AS `t0_c5`, `t`.`url` AS `t0_c6`, `t`.`full_path` AS `t0_c7`, `t`.`layout` AS `t0_c8`, `t`.`view` AS `t0_c9`, `cat_translate`.`id` AS `t1_c0`, `cat_translate`.`object_id` AS `t1_c1`, `cat_translate`.`language_id` AS `t1_c2`, `cat_translate`.`name` AS `t1_c3`, `cat_translate`.`fullname` AS `t1_c4`, `cat_translate`.`description` AS `t1_c5`, `cat_translate`.`meta_title` AS `t1_c6`, `cat_translate`.`meta_keywords` AS `t1_c7`, `cat_translate`.`meta_description` AS `t1_c8`, `cat_translate`.`tmp` AS `t1_c9` FROM `StoreCategory` `t` LEFT OUTER JOIN `StoreCategoryTranslate` `cat_translate` ON (`cat_translate`.`object_id`=`t`.`id`) WHERE ((t.id != 1) AND (`t`.`lft`<124 AND `t`.`rgt`>167)) AND (cat_translate.language_id=:language_id) ORDER BY `t`.`lft`. Bound with :language_id=’1′) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SELECT * FROM `Block` `t` WHERE `t`.`region`=:yp0 ORDER BY region ASC, position ASC. Bound with :yp0=’over_footer’) |
1 |
0.00013 |
0.00013 |
0.00013 |
0.00013 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75524′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductTranslate`) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SHOW CREATE TABLE `StoreProductDomain`) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’67782′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT * FROM `Block` `t` WHERE `t`.`region`=:yp0 ORDER BY region ASC, position ASC. Bound with :yp0=’main_phone’) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’77893′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT * FROM `Predicate` `t`) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75453′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75455′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75468′) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’20’) |
1 |
0.00012 |
0.00012 |
0.00012 |
0.00012 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75499′) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’75516′) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `t`.`id` AS `t0_c0`, `t`.`country_id` AS `t0_c1`, `t`.`region_id` AS `t0_c2`, `t`.`name` AS `t0_c3`, `t`.`altname` AS `t0_c4`, `t`.`population` AS `t0_c5`, `t`.`geonameid` AS `t0_c6`, `region`.`id` AS `t1_c0`, `region`.`country_id` AS `t1_c1`, `region`.`name` AS `t1_c2`, `region`.`altname` AS `t1_c3`, `region`.`population` AS `t1_c4`, `region`.`geonameid` AS `t1_c5` FROM `rCity` `t` LEFT OUTER JOIN `rRegion` `region` ON (`t`.`region_id`=`region`.`id`) WHERE (`t`.`name`=:yp0) AND (region.name LIKE :region_name). Bound with :yp0=’Москва’, :region_name=’Москва%’) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’34’) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
system.db.CDbCommand.query(SELECT *
FROM `AuthItem`
WHERE name=:name. Bound with :name=’admin’) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’36’) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’6669′) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’37’) |
1 |
0.00011 |
0.00011 |
0.00011 |
0.00011 |
| system.db.CDbCommand.query(SELECT * FROM `rDomain` `t` WHERE `t`.`id`=1 LIMIT 1) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT * FROM `rDomain` `t` WHERE domain=:domain OR id=1 ORDER BY id DESC LIMIT 1. Bound with :domain=’new.auto-camera.ru’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’40’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `mainImage`.`id` AS `t1_c0`, `mainImage`.`product_id` AS `t1_c1`, `mainImage`.`name` AS `t1_c2`, `mainImage`.`is_main` AS `t1_c3`, `mainImage`.`uploaded_by` AS `t1_c4`, `mainImage`.`date_uploaded` AS `t1_c5` FROM `StoreProductImage` `mainImage` WHERE (mainImage.is_main=1) AND (`mainImage`.`product_id`=:ypl0) ORDER BY date_uploaded DESC. Bound with :ypl0=’6685′) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT * FROM `StoreCurrency` `t`) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT * FROM `Block` `t` WHERE `t`.`region`=:yp0 ORDER BY region ASC, position ASC. Bound with :yp0=’sub_product’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’26’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
system.db.CDbCommand.query(SELECT `parent`
FROM `AuthItemChild`
WHERE child=:name. Bound with :name=’Admin’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
system.db.CDbCommand.query(SELECT `parent`
FROM `AuthItemChild`
WHERE child=:name. Bound with :name=’Seller’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `delivery_roles`.`id` AS `t1_c0`, `delivery_roles`.`delivery_id` AS `t1_c1`, `delivery_roles`.`role` AS `t1_c2` FROM `StoreDeliveryRole` `delivery_roles` WHERE (`delivery_roles`.`delivery_id`=:ypl0). Bound with :ypl0=’35’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `country`.`id` AS `t1_c0`, `country`.`name` AS `t1_c1`, `country`.`code` AS `t1_c2`, `country`.`population` AS `t1_c3`, `country`.`geonameid` AS `t1_c4` FROM `rCountry` `country` WHERE (`country`.`id`=:ypl0). Bound with :ypl0=’1′) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `city`.`id` AS `t1_c0`, `city`.`country_id` AS `t1_c1`, `city`.`region_id` AS `t1_c2`, `city`.`name` AS `t1_c3`, `city`.`altname` AS `t1_c4`, `city`.`population` AS `t1_c5`, `city`.`geonameid` AS `t1_c6` FROM `rCity` `city` WHERE (`city`.`id`=:ypl0). Bound with :ypl0=’0′) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
system.db.CDbCommand.query(SELECT `parent`
FROM `AuthItemChild`
WHERE child=:name. Bound with :name=’admin’) |
1 |
0.00010 |
0.00010 |
0.00010 |
0.00010 |
| system.db.CDbCommand.query(SELECT `region`.`id` AS `t1_c0`, `region`.`country_id` AS `t1_c1`, `region`.`name` AS `t1_c2`, `region`.`altname` AS `t1_c3`, `region`.`population` AS `t1_c4`, `region`.`geonameid` AS `t1_c5` FROM `rRegion` `region` WHERE (`region`.`id`=:ypl0). Bound with :ypl0=’0′) |
1 |
0.00009 |
0.00009 |
0.00009 |
0.00009 |
| system.db.CDbCommand.query(SELECT * FROM `SystemLanguage` `t`) |
1 |
0.00008 |
0.00008 |
0.00008 |
0.00008 |