Query Metrics
7
Database Queries
7
Different statements
175.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.08 ms (89.60%) |
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 415816 479929 482183 492178 494280 494931 497853 498880 499088 507108 507208 507447 512905 517185 517597 518762 519892 522119 522265 523137 523637 526977 528598 529442 530152 533684 534488 535865 541624 541898 542948 543278 546335 546392 548326 549948 550491 551114 551723 552037 552038 552040 553610 554850 556983 556993 557016 557254 557539 558342 559685 560748 560772 560859 561471 561631 563047 563153 564088 565736 566129 566223 566613 567589 569089 569529 569639 569973 570315 571864 572228 572274 575439 577646 579576 580269 580491 581038 581317 587613 587835 591544 591555 591568 592315 593077 595298 600828 604000 604336 604356 605471 616493 618685 619312 619797 622876 623304 625134 625176 625326 625463 625489 635655 637802 648488 652752 653248 658519 659408 660845 663432 673574 678857 678878 682216 682417 684977 686133 763182 ] |
||||||||||||||||||||||||||||||
|
9.29 ms (5.30%) |
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 522119 499088 507108 522265 523137 479929 569089 572274 541898 570315 581038 557539 682216 653248 684977 551114 552038 553610 566223 567589 587835 625176 591555 622876 625489 591568 593077 625463 415816 482183 498880 529442 530152 512905 517185 518762 523637 535865 497853 507208 517597 543278 548326 557016 557254 566129 566613 571864 581317 560859 563047 569973 575439 552040 560748 560772 580269 652752 673574 658519 659408 660845 686133 648488 682417 551723 552037 556983 556993 561471 561631 577646 580491 591544 616493 635655 595298 625134 604000 604336 604356 619312 494280 507447 526977 534488 494931 492178 542948 550491 558342 546335 559685 564088 569639 572228 579576 541624 563153 663432 678878 678857 546392 549948 554850 565736 569529 600828 625326 592315 618685 619797 605471 637802 587613 623304 763182 528598 519892 533684 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.48%) |
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 415816 479929 482183 492178 494280 494931 497853 498880 499088 507108 507208 507447 512905 517185 517597 518762 519892 522119 522265 523137 523637 526977 528598 529442 530152 533684 534488 535865 541624 541898 542948 543278 546335 546392 548326 549948 550491 551114 551723 552037 552038 552040 553610 554850 556983 556993 557016 557254 557539 558342 559685 560748 560772 560859 561471 561631 563047 563153 564088 565736 566129 566223 566613 567589 569089 569529 569639 569973 570315 571864 572228 572274 575439 577646 579576 580269 580491 581038 581317 587613 587835 591544 591555 591568 592315 593077 595298 600828 604000 604336 604356 605471 616493 618685 619312 619797 622876 623304 625134 625176 625326 625463 625489 635655 637802 648488 652752 653248 658519 659408 660845 663432 673574 678857 678878 682216 682417 684977 686133 763182 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс стоят"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс сто"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.78%) |
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.