Query Metrics
7
Database Queries
7
Different statements
147.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.42 ms (84.62%) |
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 148793 385880 392671 398073 406330 408402 411399 415292 418975 423773 423905 426245 438958 439307 441844 445791 450241 453714 463415 465607 466813 470923 475288 475789 495573 496781 496803 498126 505953 512173 513968 529583 529621 530436 531850 534549 534555 536907 537091 543552 546370 546923 557606 560209 562850 563204 566015 569313 575376 579673 581391 583538 585479 586962 607541 614114 658135 680439 693419 695707 695738 713437 713444 715059 720098 723889 724569 724978 725511 725512 730335 731038 731083 738835 739768 739925 740115 741073 746559 747016 748601 748710 751007 754783 757483 759842 760382 760764 760917 760973 761583 761599 765701 767187 776613 777794 795980 796343 798429 798951 799273 800206 800473 802166 803565 806230 808725 809241 811060 811679 812557 814711 816025 817160 817744 817869 818169 819952 820713 825909 ] |
||||||||||||||||||||||||||||||
|
13.71 ms (9.32%) |
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 812557 754783 723889 724569 725512 738835 739925 747016 725511 739768 751007 760382 760764 730335 746559 713437 713444 798951 802166 803565 811060 392671 411399 470923 498126 581391 466813 513968 658135 731083 740115 760973 715059 415292 560209 475789 529583 566015 546923 720098 693419 695707 585479 614114 777794 798429 724978 761599 765701 795980 796343 811679 767187 757483 806230 423773 495573 569313 546370 586962 818169 450241 463415 537091 465607 543552 607541 453714 438958 445791 505953 530436 575376 418975 825909 817744 496781 529621 531850 475288 562850 583538 563204 695738 557606 579673 800206 809241 748710 800473 731038 748601 760917 741073 759842 776613 799273 808725 441844 398073 148793 439307 496803 680439 761583 385880 406330 408402 423905 426245 816025 814711 819952 817160 817869 820713 534549 512173 534555 536907 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.50%) |
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 148793 385880 392671 398073 406330 408402 411399 415292 418975 423773 423905 426245 438958 439307 441844 445791 450241 453714 463415 465607 466813 470923 475288 475789 495573 496781 496803 498126 505953 512173 513968 529583 529621 530436 531850 534549 534555 536907 537091 543552 546370 546923 557606 560209 562850 563204 566015 569313 575376 579673 581391 583538 585479 586962 607541 614114 658135 680439 693419 695707 695738 713437 713444 715059 720098 723889 724569 724978 725511 725512 730335 731038 731083 738835 739768 739925 740115 741073 746559 747016 748601 748710 751007 754783 757483 759842 760382 760764 760917 760973 761583 761599 765701 767187 776613 777794 795980 796343 798429 798951 799273 800206 800473 802166 803565 806230 808725 809241 811060 811679 812557 814711 816025 817160 817744 817869 818169 819952 820713 825909 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pantyhose ass milf"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pantyhose жоп milf"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pantyhose жоп 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.