Query Metrics
7
Database Queries
7
Different statements
149.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.72 ms (81.32%) |
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 137159 391944 392930 397605 398077 398615 400489 409938 409939 417840 418059 421814 421939 424096 424180 424248 428709 429609 429879 433240 433353 439704 439707 439802 440781 440872 440906 441094 441113 441353 442095 444836 445397 445464 445720 446404 454548 455995 457431 457453 457455 459837 460001 460343 461322 464226 464975 465545 467103 468269 469420 470851 478420 478450 478582 480254 480497 480682 482197 491056 491164 493679 514656 516480 518922 521160 525878 532271 535855 538879 542273 543297 549836 552290 552294 562342 565648 585964 599710 607963 609071 642290 650969 663772 713433 714042 717134 718524 725135 726244 729289 733265 740647 745517 749598 753614 758823 759717 760859 765463 766124 768233 769312 769491 771179 794135 796132 796808 796905 797461 799351 810088 814399 824075 824442 824584 824845 825221 826531 827489 ] |
||||||||||||||||||||||||||||||
|
19.20 ms (12.83%) |
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 445397 445720 464975 478450 400489 433353 516480 824845 392930 397605 441353 409939 428709 440781 409938 418059 429609 442095 826531 824584 825221 469420 480254 493679 467103 491056 521160 535855 663772 599710 796132 797461 769312 771179 766124 796905 465545 424180 482197 421814 429879 478582 460343 440906 421939 441094 478420 514656 491164 454548 552294 439707 439802 457455 424096 433240 439704 444836 552290 562342 726244 760859 457453 525878 137159 814399 824075 455995 650969 398615 824442 827489 470851 538879 480682 717134 729289 733265 768233 745517 753614 759717 769491 607963 718524 796808 417840 459837 398077 543297 542273 565648 713433 749598 810088 518922 480497 464226 391944 440872 424248 441113 445464 446404 457431 461322 468269 532271 460001 714042 549836 609071 585964 642290 794135 799351 725135 740647 758823 765463 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.72%) |
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 137159 391944 392930 397605 398077 398615 400489 409938 409939 417840 418059 421814 421939 424096 424180 424248 428709 429609 429879 433240 433353 439704 439707 439802 440781 440872 440906 441094 441113 441353 442095 444836 445397 445464 445720 446404 454548 455995 457431 457453 457455 459837 460001 460343 461322 464226 464975 465545 467103 468269 469420 470851 478420 478450 478582 480254 480497 480682 482197 491056 491164 493679 514656 516480 518922 521160 525878 532271 535855 538879 542273 543297 549836 552290 552294 562342 565648 585964 599710 607963 609071 642290 650969 663772 713433 714042 717134 718524 725135 726244 729289 733265 740647 745517 749598 753614 758823 759717 760859 765463 766124 768233 769312 769491 771179 794135 796132 796808 796905 797461 799351 810088 814399 824075 824442 824584 824845 825221 826531 827489 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby жен анал"
]
|
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.