Query Metrics
7
Database Queries
7
Different statements
143.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.61 ms (82.72%) |
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 529689 530568 531699 532845 533183 533898 537157 539324 539632 539752 540077 541787 542442 543679 544321 548313 551197 554703 555674 559917 563086 563512 564875 566555 577609 578072 579667 579809 583224 590137 592148 593317 593589 594805 601255 601468 606242 606331 606809 607128 607703 616359 620363 623633 625679 626889 629659 636258 636324 639231 639726 639836 641337 643031 643727 646043 647030 647919 650446 650969 651198 680614 682276 692683 692744 692763 709347 710328 710786 714215 714836 715364 716215 718025 720775 720814 722160 738004 742247 746097 748202 753338 769834 775010 778655 780399 781828 782479 785243 789294 790612 791673 792787 793251 795847 797057 798864 800800 802228 802301 803717 804296 805097 805979 806993 807724 812382 815787 817172 817176 819125 821542 822620 825183 826303 826749 828008 828110 828136 828294 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (10.59%) |
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 826749 815787 817172 817176 819125 821542 822620 825183 826303 828008 828110 828294 828136 532845 533183 539324 539632 533898 539752 540077 529689 530568 531699 537157 554703 555674 542442 544321 551197 579667 579809 583224 541787 543679 548313 559917 563086 563512 564875 566555 577609 646043 647919 650446 650969 692763 709347 722160 682276 692683 692744 714215 714836 647030 651198 680614 710328 710786 715364 716215 718025 720775 720814 578072 590137 594805 606331 620363 636258 636324 639726 593317 593589 643727 601255 601468 606242 616359 639836 641337 592148 606809 607128 607703 623633 625679 626889 629659 639231 643031 778655 781828 782479 790612 795847 797057 800800 802228 802301 806993 807724 775010 780399 789294 791673 793251 798864 803717 804296 805097 805979 812382 738004 742247 746097 748202 753338 769834 785243 792787 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.82%) |
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 529689 530568 531699 532845 533183 533898 537157 539324 539632 539752 540077 541787 542442 543679 544321 548313 551197 554703 555674 559917 563086 563512 564875 566555 577609 578072 579667 579809 583224 590137 592148 593317 593589 594805 601255 601468 606242 606331 606809 607128 607703 616359 620363 623633 625679 626889 629659 636258 636324 639231 639726 639836 641337 643031 643727 646043 647030 647919 650446 650969 651198 680614 682276 692683 692744 692763 709347 710328 710786 714215 714836 715364 716215 718025 720775 720814 722160 738004 742247 746097 748202 753338 769834 775010 778655 780399 781828 782479 785243 789294 790612 791673 792787 793251 795847 797057 798864 800800 802228 802301 803717 804296 805097 805979 806993 807724 812382 815787 817172 817176 819125 821542 822620 825183 826303 826749 828008 828110 828136 828294 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf glasses"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf очкастая"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf очкастая"
]
|
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.