کارشناس فروش و مارکتینگ
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`.`tags` AS `Tag` WHERE `Tag`.`id` = 81 | 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_tags` LEFT JOIN products_attributes ON products_tags.product_id=products_attributes.product_id LEFT JOIN attributes ON products_attributes.attribute_id=attributes.id WHERE tag_id=81 AND attribute_id IS NOT NULL GROUP BY attribute_id HAVING values_count>1 AND values_count<=100 ORDER BY sortorder ASC | 17 | 17 | 1753 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`name`, `Tag`.`image`, `Tag`.`type`, `Tag`.`description`, `Tag`.`hidden` FROM `c1_db_main`.`tags` AS `Tag` WHERE `Tag`.`id` = 81 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`, `ProductsTag`.`id`, `ProductsTag`.`product_id`, `ProductsTag`.`tag_id` FROM `c1_db_main`.`products` AS `Product` JOIN `c1_db_main`.`products_tags` AS `ProductsTag` ON (`ProductsTag`.`tag_id` = 81 AND `ProductsTag`.`product_id` = `Product`.`id`) LIMIT 20 | 20 | 20 | 2 | 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 (527, 528, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 541, 542, 543, 544, 545, 547, 548, 549) 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_tags` `ProductsTag` ON `ProductsTag`.`product_id`=`Product`.`id` WHERE `ProductsTag`.`tag_id` = 81 | 1 | 1 | 5 | maybe slow |
Peak Memory Use 10.55 MB
Message | Memory use |
---|---|
Component initialization | 5.17 MB |
Controller action start | 5.45 MB |
Controller render start | 6.67 MB |
View render complete | 7.49 MB |
Total Request Time: 2535 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 151.28 | |
Event: Controller.initialize | 2.52 | |
Event: Controller.startup | 0.91 | |
Controller action | 1779.46 | |
Event: Controller.beforeRender | 34.91 | |
» Processing toolbar data | 25.91 | |
Rendering View | 461.53 | |
» Event: View.beforeRender | 0.06 | |
» Rendering APP/View/Tags/view.ctp | 395.99 | |
» Event: View.afterRender | 0.43 | |
» Event: View.beforeLayout | 0.08 | |
» Rendering APP/View/Layouts/default.ctp | 63.67 | |
Event: View.afterLayout | 0.00 |
Time | Message |
---|---|
2025-09-18 02:50:56 | Creating thumbnail for datees-DB-135-1-l.png |
2025-09-18 02:50:56 | Error in opening file. |
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 | /tags/view/81 |
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.127.207 |
Remote Port | 28634 |
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 | 980c5645cfb00003-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 | 1758151254.3681 |
Request Time | 1758151254 |