کارشناس فروش و مارکتینگ
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` = 26 | 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=26 AND attribute_id IS NOT NULL GROUP BY attribute_id HAVING values_count>1 AND values_count<=100 ORDER BY sortorder ASC | 0 | 0 | 3 | 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` = 26 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` = 26 AND `ProductsCategory`.`product_id` = `Product`.`id`) ORDER BY `Product`.`quantity`>0 DESC, `Product`.`visitcount` DESC, `Product`.`buycount` DESC, `Product`.`id` DESC LIMIT 20 | 0 | 0 | 3 | 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` = 26 | 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 | 1 |
Peak Memory Use 10.12 MB
Message | Memory use |
---|---|
Component initialization | 4.91 MB |
Controller action start | 5.19 MB |
Controller render start | 6.18 MB |
View render complete | 7.22 MB |
Total Request Time: 438 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 142.36 | |
Event: Controller.initialize | 15.18 | |
Event: Controller.startup | 5.02 | |
Controller action | 68.97 | |
Event: Controller.beforeRender | 25.83 | |
» Processing toolbar data | 20.41 | |
Rendering View | 73.52 | |
» Event: View.beforeRender | 0.06 | |
» Rendering APP/View/Categories/view.ctp | 6.71 | |
» » Rendering APP/View/Elements/categories_view_nav.ctp | 4.73 | |
» Event: View.afterRender | 0.24 | |
» Event: View.beforeLayout | 0.05 | |
» Rendering APP/View/Layouts/default.ctp | 65.32 | |
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 | /%D9%84%D9%88%D8%A7%D8%B2%D9%85-%D8%B3%D8%B1%D9%88%DB%8C%D8%B3-%D8%A8%D9%87%D8%AF%D8%A7%D8%B4%D8%AA%DB%8C-%D9%88-%D8%AD%D9%85%D8%A7%D9%85 |
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.69.59.206 |
Remote Port | 40962 |
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 X Forwarded For | 216.73.216.34 |
Http Cf Ray | 980f6c15e92510c6-ORD |
Http Accept | */* |
Http Accept Encoding | gzip, br |
Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) |
Http Cdn Loop | cloudflare; loops=1 |
Http Cf Connecting Ip | 216.73.216.34 |
Http Cf Ipcountry | US |
Http Cf Visitor | {"scheme":"https"} |
Http X Forwarded Proto | https |
Php Self | /index.php |
Request Time Float | 1758183604.8146 |
Request Time | 1758183604 |