Query Metrics
7
Database Queries
7
Different statements
235.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.42 ms (89.86%) |
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 28568 249009 397663 400730 410663 413958 451213 457228 459638 459963 462763 470400 513169 536432 539275 541678 549627 552697 564103 575846 586006 592300 592644 603391 603785 604362 618362 619273 619828 619974 624196 625960 627362 632111 636943 640457 654187 656931 662142 662181 663721 668942 669003 670904 672894 683092 683270 684410 704377 711870 714672 719314 720103 720418 726282 727739 730340 730347 731346 735602 739230 739389 740241 740819 740882 745135 745682 746884 752565 754070 756551 757178 757388 759759 759926 760983 761594 761706 762085 765234 765285 765353 765657 765756 765835 765940 766600 766680 767017 767058 767235 767326 770267 771041 783194 783271 784740 784890 785832 788592 788650 788838 790515 790523 791416 792100 795623 795628 795822 796126 796157 796162 797065 797189 797310 800508 800633 817721 820165 824028 ] |
||||||||||||||||||||||||||||||
|
13.39 ms (5.69%) |
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 730340 783194 766680 759759 767017 765756 714672 249009 541678 575846 711870 619974 604362 656931 539275 684410 668942 672894 636943 757388 397663 459638 795623 796157 767058 720418 784890 28568 760983 752565 662181 770267 817721 824028 767235 745682 740819 745135 740241 470400 586006 603391 783271 800508 740882 754070 761594 767326 735602 765353 739389 746884 765657 784740 788650 790523 791416 410663 592644 765940 759926 790515 792100 756551 730347 731346 462763 820165 564103 788592 765835 739230 625960 640457 704377 788838 662142 663721 670904 603785 400730 619828 624196 592300 619273 627362 654187 549627 727739 797065 795628 761706 762085 765285 771041 552697 413958 451213 459963 513169 669003 720103 796162 797189 765234 766600 719314 795822 796126 797310 457228 785832 726282 800633 757178 618362 683270 683092 632111 536432 ] |
||||||||||||||||||||||||||||||
|
4.39 ms (1.87%) |
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 28568 249009 397663 400730 410663 413958 451213 457228 459638 459963 462763 470400 513169 536432 539275 541678 549627 552697 564103 575846 586006 592300 592644 603391 603785 604362 618362 619273 619828 619974 624196 625960 627362 632111 636943 640457 654187 656931 662142 662181 663721 668942 669003 670904 672894 683092 683270 684410 704377 711870 714672 719314 720103 720418 726282 727739 730340 730347 731346 735602 739230 739389 740241 740819 740882 745135 745682 746884 752565 754070 756551 757178 757388 759759 759926 760983 761594 761706 762085 765234 765285 765353 765657 765756 765835 765940 766600 766680 767017 767058 767235 767326 770267 771041 783194 783271 784740 784890 785832 788592 788650 788838 790515 790523 791416 792100 795623 795628 795822 796126 796157 796162 797065 797189 797310 800508 800633 817721 820165 824028 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hard amateur anal"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hard любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hard любительск анал"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.