Query Metrics
7
Database Queries
7
Different statements
166.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.98 ms (82.33%) |
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 385014 408759 415779 429649 444402 453708 454097 465099 471478 474622 476207 476379 481649 482683 487937 490047 491813 492329 493177 493466 494051 494496 497834 498264 503353 503964 506349 507876 509310 509494 511774 511845 512984 513240 513692 514047 514818 518050 520754 521152 521752 521778 522475 523037 523132 523481 523855 525174 525497 525761 527163 527383 528088 531521 536559 536876 541220 545788 550759 553298 555936 556501 556860 558234 558810 561290 563988 565475 566065 568316 568325 568928 571144 573165 574191 574269 578421 579633 579828 580920 582342 583191 583257 586641 586806 589658 590254 591849 591918 591947 594126 596251 598343 599217 600983 601160 601200 602999 603949 605989 606192 607462 611253 615964 617118 618137 620331 620569 620591 625557 626243 653486 663454 667195 669778 670102 670676 681539 686207 690846 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (12.23%) |
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 598343 511774 513692 663454 523132 490047 591947 521778 527163 566065 568928 583257 590254 607462 626243 580920 385014 550759 506349 606192 615964 523481 525497 686207 653486 491813 518050 556860 553298 578421 625557 611253 453708 454097 579828 561290 574191 670102 596251 600983 690846 670676 563988 586641 601200 531521 429649 594126 599217 565475 444402 492329 555936 591918 521752 493466 618137 408759 523037 514047 556501 498264 493177 536876 523855 503353 521152 583191 681539 494051 669778 586806 617118 476379 558234 591849 511845 522475 568316 574269 605989 602999 512984 582342 601160 603949 494496 507876 497834 528088 579633 482683 476207 536559 474622 545788 568325 620591 527383 481649 509310 514818 525761 589658 620331 620569 415779 465099 471478 487937 513240 520754 503964 509494 525174 558810 573165 541220 571144 667195 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.38%) |
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 385014 408759 415779 429649 444402 453708 454097 465099 471478 474622 476207 476379 481649 482683 487937 490047 491813 492329 493177 493466 494051 494496 497834 498264 503353 503964 506349 507876 509310 509494 511774 511845 512984 513240 513692 514047 514818 518050 520754 521152 521752 521778 522475 523037 523132 523481 523855 525174 525497 525761 527163 527383 528088 531521 536559 536876 541220 545788 550759 553298 555936 556501 556860 558234 558810 561290 563988 565475 566065 568316 568325 568928 571144 573165 574191 574269 578421 579633 579828 580920 582342 583191 583257 586641 586806 589658 590254 591849 591918 591947 594126 596251 598343 599217 600983 601160 601200 602999 603949 605989 606192 607462 611253 615964 617118 618137 620331 620569 620591 625557 626243 653486 663454 667195 669778 670102 670676 681539 686207 690846 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"jerking tits"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.