Query Metrics
7
Database Queries
7
Different statements
171.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.89 ms (86.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 419731 455114 456686 458740 461496 461540 461547 462038 462042 466113 467130 472788 473546 476501 477121 480852 481673 481679 487074 488201 488206 489621 491666 491867 492386 493394 507802 508819 511703 511728 512251 512668 513274 513278 514384 514385 514462 519608 520661 524707 526135 526415 527630 537525 538544 552141 589782 605523 610664 654625 654711 654784 654806 654827 655072 655092 655356 655401 655418 655421 655611 655625 655706 656084 656386 656423 656432 656684 656790 656958 656965 656982 656988 657101 657352 657360 657371 657391 657403 657431 657592 657686 657706 657730 658000 658045 658055 658248 658315 658326 658337 658646 658719 658752 659087 659145 659496 659521 659541 659601 659620 659695 659755 659794 659825 659833 660544 660562 660967 665249 713088 741293 744900 744917 747889 788657 788692 789382 790931 808687 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (7.35%) |
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 472788 476501 481673 481679 456686 467130 455114 461540 477121 419731 461547 462038 462042 480852 461496 466113 473546 512251 514462 520661 526135 487074 489621 507802 513274 513278 514385 526415 527630 488201 511703 512668 514384 538544 488206 491666 492386 493394 508819 511728 519608 491867 537525 654827 655401 656386 656432 656790 656988 657360 657403 657431 657686 657730 658248 658315 658326 658646 658719 659145 659496 659755 654711 655072 655421 655706 657352 657371 657391 657592 658000 658045 658337 658752 659087 659521 659541 659794 660544 654625 654784 654806 655092 655356 655418 655611 655625 656084 656423 656684 656958 656965 656982 657101 657706 658055 659601 659620 659695 659825 659833 660562 660967 665249 713088 552141 610664 605523 589782 790931 808687 788657 789382 741293 747889 744917 744900 788692 458740 524707 ] |
||||||||||||||||||||||||||||||
|
2.55 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 419731 455114 456686 458740 461496 461540 461547 462038 462042 466113 467130 472788 473546 476501 477121 480852 481673 481679 487074 488201 488206 489621 491666 491867 492386 493394 507802 508819 511703 511728 512251 512668 513274 513278 514384 514385 514462 519608 520661 524707 526135 526415 527630 537525 538544 552141 589782 605523 610664 654625 654711 654784 654806 654827 655072 655092 655356 655401 655418 655421 655611 655625 655706 656084 656386 656423 656432 656684 656790 656958 656965 656982 656988 657101 657352 657360 657371 657391 657403 657431 657592 657686 657706 657730 658000 658045 658055 658248 658315 658326 658337 658646 658719 658752 659087 659145 659496 659521 659541 659601 659620 659695 659755 659794 659825 659833 660544 660562 660967 665249 713088 741293 744900 744917 747889 788657 788692 789382 790931 808687 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful cuckold"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая куколд"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.94%) |
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.