مقایسه
مشاهده محصول کارشناس فروش و مارکتینگ
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT COUNT(*) AS `count` FROM `c1_db_main`.`categories` AS `Category` WHERE `Category`.`id` = 33 | 1 | 1 | 0 | |
| SELECT attribute_id, name, COUNT(DISTINCT value)-1 AS values_count, GROUP_CONCAT(DISTINCT products_attributes.`value` ORDER BY `value` SEPARATOR '|') AS `values` FROM `products_categories` LEFT JOIN products_attributes ON products_categories.product_id=products_attributes.product_id LEFT JOIN attributes ON products_attributes.attribute_id=attributes.id WHERE category_id=33 AND attribute_id IS NOT NULL GROUP BY attribute_id HAVING values_count>1 AND values_count<=100 ORDER BY sortorder ASC | 3 | 3 | 346 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`page_title`, `Category`.`article_title`, `Category`.`parent_id`, `Category`.`image`, `Category`.`homerollover`, `Category`.`description` FROM `c1_db_main`.`categories` AS `Category` WHERE `Category`.`id` = 33 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`model`, `Product`.`url`, `Product`.`page_title`, `Product`.`article_title`, `Product`.`oldprice`, `Product`.`newprice`, `Product`.`pricebase`, `Product`.`pricechangetype`, `Product`.`pricechangeamount`, `Product`.`quantity`, `Product`.`shipping`, `Product`.`manufacture_id`, `Product`.`sortorder`, `Product`.`availabletodate`, `Product`.`length`, `Product`.`width`, `Product`.`height`, `Product`.`weight`, `Product`.`points`, `Product`.`body`, `Product`.`visitcount`, `Product`.`buycount`, `Product`.`description`, `Product`.`newproduct`, `Product`.`popularproduct`, `Product`.`specialproduct`, `ProductsCategory`.`id`, `ProductsCategory`.`product_id`, `ProductsCategory`.`category_id` FROM `c1_db_main`.`products` AS `Product` JOIN `c1_db_main`.`products_categories` AS `ProductsCategory` ON (`ProductsCategory`.`category_id` = 33 AND `ProductsCategory`.`product_id` = `Product`.`id`) ORDER BY `Product`.`quantity`>0 DESC, `Product`.`visitcount` DESC, `Product`.`buycount` DESC, `Product`.`id` DESC LIMIT 20 | 20 | 20 | 3 | maybe slow |
| SELECT `Image`.`id`, `Image`.`name`, `ProductsImage`.`id`, `ProductsImage`.`product_id`, `ProductsImage`.`image_id` FROM `c1_db_main`.`images` AS `Image` JOIN `c1_db_main`.`products_images` AS `ProductsImage` ON (`ProductsImage`.`product_id` IN (1283, 1268, 1273, 1286, 1269, 1292, 1285, 1284, 1267, 1301, 1326, 1291, 1321, 1320, 1270, 1302, 1316, 1318, 1345, 1338) AND `ProductsImage`.`image_id` = `Image`.`id`) | 20 | 20 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `c1_db_main`.`products` AS `Product` LEFT JOIN `c1_db_main`.`manufactures` AS `Manufacture` ON (`Product`.`manufacture_id` = `Manufacture`.`id`) LEFT JOIN `products_categories` `ProductsCategory` ON `ProductsCategory`.`product_id`=`Product`.`id` WHERE `ProductsCategory`.`category_id` = 33 | 1 | 1 | 2 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`url`, `Category`.`page_title`, `Category`.`article_title`, `Category`.`parent_id`, `Category`.`image`, `Category`.`homerollover`, `Category`.`description` FROM `c1_db_main`.`categories` AS `Category` WHERE 1 = 1 | 45 | 45 | 0 |
Peak Memory Use 10.43 MB
| Message | Memory use |
|---|---|
| Component initialization | 4.91 MB |
| Controller action start | 5.19 MB |
| Controller render start | 6.38 MB |
| View render complete | 7.47 MB |
Total Request Time: 1185 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 149.36 | |
| Event: Controller.initialize | 10.20 | |
| Event: Controller.startup | 3.39 | |
| Controller action | 395.45 | |
| Event: Controller.beforeRender | 23.55 | |
| » Processing toolbar data | 18.34 | |
| Rendering View | 484.19 | |
| » Event: View.beforeRender | 0.06 | |
| » Rendering APP/View/Categories/view.ctp | 412.90 | |
| » Event: View.afterRender | 0.25 | |
| » Event: View.beforeLayout | 0.05 | |
| » Rendering APP/View/Layouts/default.ctp | 69.63 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| APP | /var/www/clients/client1/web1/web/app/ |
| APP_DIR | app |
| APPLIBS | /var/www/clients/client1/web1/web/app/Lib/ |
| CACHE | /var/www/clients/client1/web1/web/app/tmp/cache/ |
| CAKE | /var/www/clients/client1/web1/web/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/clients/client1/web1/web/lib |
| CORE_PATH | /var/www/clients/client1/web1/web/lib/ |
| CAKE_VERSION | 2.5.7 |
| CSS | /var/www/clients/client1/web1/web/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://karajhood.ir |
| IMAGES | /var/www/clients/client1/web1/web/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/clients/client1/web1/web/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/clients/client1/web1/web/app/tmp/logs/ |
| ROOT | /var/www/clients/client1/web1/web |
| TESTS | /var/www/clients/client1/web1/web/app/Test/ |
| TMP | /var/www/clients/client1/web1/web/app/tmp/ |
| VENDORS | /var/www/clients/client1/web1/web/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/clients/client1/web1/web/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 5.6.40-86+0~20250817.110+debian12~1.gbp00d7b7 |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin |
| Temp | /var/www/clients/client1/web1/tmp |
| Tmpdir | /var/www/clients/client1/web1/tmp |
| Tmp | /var/www/clients/client1/web1/tmp |
| Hostname | |
| User | web1 |
| Home | /var/www/clients/client1/web1 |
| Fcgi Role | RESPONDER |
| Query String | |
| Request Method | GET |
| Content Type | |
| Content Length | |
| Script Name | /index.php |
| Request Uri | /%D8%B4%DB%8C%D8%B1%D8%A2%D9%84%D8%A7%D8%AA-%D8%B4%D8%A7%D9%87%DB%8C%D9%86-%D8%B4%DB%8C%D8%B1 |
| Document Uri | /index.php |
| Document Root | /var/www/karajhood.ir/web/app/webroot |
| Server Protocol | HTTP/2.0 |
| Request Scheme | https |
| Https | on |
| Gateway Interface | CGI/1.1 |
| Server Software | nginx/1.22.1 |
| Remote Addr | 172.70.100.172 |
| Remote Port | 42566 |
| Remote User | |
| Server Addr | 185.81.96.42 |
| Server Port | 443 |
| Server Name | karajhood.ir |
| Redirect Status | 200 |
| Script Filename | /var/www/karajhood.ir/web/app/webroot/index.php |
| Http Host | karajhood.ir |
| Http Cf Ray | 980c5449c96feb61-ORD |
| Http X Forwarded For | 216.73.216.34 |
| Http Cf Connecting Ip | 216.73.216.34 |
| Http Cdn Loop | cloudflare; loops=1 |
| Http Accept Encoding | gzip, br |
| Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) |
| Http X Forwarded Proto | https |
| Http Accept | */* |
| Http Cf Ipcountry | US |
| Http Cf Visitor | {"scheme":"https"} |
| Php Self | /index.php |
| Request Time Float | 1758151173.0954 |
| Request Time | 1758151173 |
