Query Metrics
7
Database Queries
7
Different statements
351.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.75 ms (58.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐüð░ð Ðçð╗ðÁð¢ð░ ðÂðÁð¢Ðëð©ð¢ð¥ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
118.89 ms (33.82%) |
1 |
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id AND f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id` AND `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 23104 266369 383483 393431 395564 395750 402092 404316 410615 421328 423763 424811 426841 430236 430313 430707 440292 449881 454409 459708 460739 469287 472247 478940 482139 485813 487887 488130 491413 498056 503792 505460 506135 506436 507779 511564 513823 522477 523384 525116 527415 527451 528823 529903 531545 532113 532133 532908 534288 548592 548596 549744 550585 552593 556916 557526 563093 564767 564814 565716 567743 568156 571058 571839 572603 580769 581427 582024 582558 586678 587925 590897 591306 596096 601884 604555 604703 607170 610179 610261 610647 617175 619920 620319 629766 634824 637444 640716 641130 644373 654683 676421 687500 689584 705356 720532 721737 726528 731134 736432 741190 742404 756063 760648 760830 762514 795322 804594 813409 814293 814850 814883 815288 815963 816207 816918 826260 826265 826481 828417 ] |
||||||||||||||||||||||||||||||
|
16.94 ms (4.82%) |
1 |
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id` AND `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 424811 402092 814293 550585 557526 591306 430313 478940 629766 571058 491413 23104 506135 587925 596096 634824 760830 741190 742404 421328 527415 531545 814850 641130 582024 586678 610261 804594 581427 460739 503792 637444 619920 395564 580769 571839 506436 572603 582558 676421 610647 565716 726528 513823 528823 610179 620319 548592 654683 532908 472247 449881 454409 826265 564767 604703 601884 687500 590897 505460 469287 814883 549744 816918 826481 816207 760648 525116 534288 430707 523384 410615 522477 567743 511564 498056 404316 563093 564814 731134 705356 815963 644373 720532 527451 640716 828417 548596 756063 426841 826260 813409 393431 604555 459708 440292 532113 488130 266369 556916 815288 532133 395750 795322 487887 552593 507779 568156 721737 485813 762514 689584 607170 430236 617175 529903 383483 736432 482139 423763 ] |
||||||||||||||||||||||||||||||
|
4.07 ms (1.16%) |
1 |
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 23104 266369 383483 393431 395564 395750 402092 404316 410615 421328 423763 424811 426841 430236 430313 430707 440292 449881 454409 459708 460739 469287 472247 478940 482139 485813 487887 488130 491413 498056 503792 505460 506135 506436 507779 511564 513823 522477 523384 525116 527415 527451 528823 529903 531545 532113 532133 532908 534288 548592 548596 549744 550585 552593 556916 557526 563093 564767 564814 565716 567743 568156 571058 571839 572603 580769 581427 582024 582558 586678 587925 590897 591306 596096 601884 604555 604703 607170 610179 610261 610647 617175 619920 620319 629766 634824 637444 640716 641130 644373 654683 676421 687500 689584 705356 720532 721737 726528 731134 736432 741190 742404 756063 760648 760830 762514 795322 804594 813409 814293 814850 814883 815288 815963 816207 816918 826260 826265 826481 828417 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж член женщин"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.54%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж член женщин"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.