Query Metrics
7
Database Queries
7
Different statements
178.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.24 ms (84.89%) |
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 403588 420758 426968 427065 435433 435434 440973 446851 448074 453497 459513 460088 466059 467975 468984 472566 475163 479959 485463 488380 490253 507865 508880 508987 510083 511155 513506 518621 519354 521077 521502 523231 524156 524180 524359 525555 527839 528661 555995 556481 560737 561503 561909 562428 564656 577501 583868 585231 589036 590309 605485 606032 608558 609707 609933 610862 612087 625460 626885 632124 633959 636174 639895 641870 649094 659367 668969 669712 674486 677222 682348 682413 687150 698106 700858 705642 712226 721978 725097 727724 731325 732733 733458 734189 737365 740646 740966 741076 741082 742607 742771 744234 748545 748855 749756 759833 768394 778905 779841 780831 782122 786595 794929 796472 796610 796826 797292 799459 800814 803590 805350 808633 809992 817342 820164 823565 824803 825270 826058 828782 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (9.18%) |
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 510083 560737 440973 527839 528661 485463 488380 435433 513506 609933 636174 826058 828782 820164 734189 825270 561503 800814 823565 585231 786595 759833 742607 824803 682413 698106 610862 733458 742771 796610 817342 562428 639895 803590 778905 779841 782122 748855 768394 737365 712226 641870 805350 727724 748545 426968 659367 721978 583868 780831 740966 725097 749756 700858 796472 460088 590309 605485 609707 808633 740646 809992 797292 674486 632124 796826 741082 744234 741076 705642 459513 472566 669712 677222 649094 687150 608558 799459 731325 479959 427065 468984 453497 511155 524180 508880 524359 561909 668969 606032 625460 633959 794929 435434 518621 508987 524156 523231 507865 556481 577501 555995 682348 564656 519354 490253 466059 475163 732733 446851 448074 525555 521502 403588 467975 420758 521077 589036 612087 626885 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.64%) |
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 403588 420758 426968 427065 435433 435434 440973 446851 448074 453497 459513 460088 466059 467975 468984 472566 475163 479959 485463 488380 490253 507865 508880 508987 510083 511155 513506 518621 519354 521077 521502 523231 524156 524180 524359 525555 527839 528661 555995 556481 560737 561503 561909 562428 564656 577501 583868 585231 589036 590309 605485 606032 608558 609707 609933 610862 612087 625460 626885 632124 633959 636174 639895 641870 649094 659367 668969 669712 674486 677222 682348 682413 687150 698106 700858 705642 712226 721978 725097 727724 731325 732733 733458 734189 737365 740646 740966 741076 741082 742607 742771 744234 748545 748855 749756 759833 768394 778905 779841 780831 782122 786595 794929 796472 796610 796826 797292 799459 800814 803590 805350 808633 809992 817342 820164 823565 824803 825270 826058 828782 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband not home"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband home"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband home"
]
|
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.