Query Metrics
7
Database Queries
7
Different statements
200.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.30 ms (88.05%) |
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 384977 386195 386725 387648 447136 464419 468345 474263 483312 498126 499042 521860 522253 530118 537593 537645 538165 541756 546666 555506 557630 564674 576511 581275 583777 587220 593919 599927 605186 606788 614851 615057 616178 619997 622790 633435 634585 635073 635662 635721 653347 655005 655163 655683 656363 660999 662474 667803 669346 678876 681646 681663 686148 690842 696058 698788 707576 713683 714808 716288 717048 717955 718134 720323 723056 723116 723522 726263 728887 730790 732226 732982 734268 743941 745249 747239 749007 752235 753189 759483 760120 764667 767401 778058 781325 781963 785157 786199 788068 791306 792815 794299 794408 794567 795130 796710 797215 802312 804612 805001 807887 808836 811087 812083 813647 813817 816598 816637 816744 816815 818240 821388 822482 822848 825011 825156 825708 825710 826545 827601 ] |
||||||||||||||||||||||||||||||
|
13.24 ms (6.61%) |
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 822848 821388 468345 521860 530118 538165 499042 698788 662474 669346 713683 634585 635721 622790 785157 797215 811087 728887 749007 753189 788068 796710 807887 726263 734268 732982 635073 717048 723116 599927 818240 816744 447136 537593 716288 760120 635662 804612 633435 826545 816815 464419 555506 681646 690842 781963 786199 791306 812083 732226 767401 614851 795130 498126 743941 587220 792815 386195 747239 386725 816637 813647 813817 825710 474263 483312 522253 537645 546666 660999 720323 606788 794299 794408 808836 781325 794567 802312 805001 752235 730790 745249 759483 764667 605186 615057 778058 384977 387648 822482 825011 723522 825708 825156 816598 827601 541756 581275 557630 583777 656363 678876 696058 714808 717955 653347 655005 667803 681663 686148 707576 723056 655163 655683 718134 564674 576511 593919 616178 619997 ] |
||||||||||||||||||||||||||||||
|
3.55 ms (1.77%) |
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 384977 386195 386725 387648 447136 464419 468345 474263 483312 498126 499042 521860 522253 530118 537593 537645 538165 541756 546666 555506 557630 564674 576511 581275 583777 587220 593919 599927 605186 606788 614851 615057 616178 619997 622790 633435 634585 635073 635662 635721 653347 655005 655163 655683 656363 660999 662474 667803 669346 678876 681646 681663 686148 690842 696058 698788 707576 713683 714808 716288 717048 717955 718134 720323 723056 723116 723522 726263 728887 730790 732226 732982 734268 743941 745249 747239 749007 752235 753189 759483 760120 764667 767401 778058 781325 781963 785157 786199 788068 791306 792815 794299 794408 794567 795130 796710 797215 802312 804612 805001 807887 808836 811087 812083 813647 813817 816598 816637 816744 816815 818240 821388 822482 822848 825011 825156 825708 825710 826545 827601 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love big"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love большие"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love большие"
]
|
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.