Query Metrics
7
Database Queries
7
Different statements
164.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.99 ms (83.16%) |
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 384878 392109 397766 397895 401049 410090 426712 427183 443132 443926 446314 450577 453625 453651 454129 454137 460781 462329 462539 462717 466002 469890 470391 470508 470529 470535 470579 470611 470620 470675 470678 470955 473969 474007 474036 474488 474923 476426 478553 479087 479092 479108 482489 485589 490261 490307 492690 492697 500625 504268 504295 509853 510427 510747 522523 522662 523877 524613 533648 534074 534132 541246 542370 542747 542765 543677 543760 543982 544177 545642 548900 548905 552783 554563 555688 556432 557937 557945 559644 559716 563400 567388 575420 590375 590631 590693 603239 611723 614698 618236 628181 649094 649266 654695 659287 673533 692172 694639 708134 709295 723074 730210 733830 742046 754644 755723 770788 778156 781264 792493 792510 793915 794247 797799 799672 802018 805368 809184 809765 819767 ] |
||||||||||||||||||||||||||||||
|
16.56 ms (10.05%) |
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 673533 805368 492697 510747 401049 557937 504295 392109 809184 397895 482489 563400 470508 649266 443132 470678 556432 548900 543760 450577 733830 453625 534132 534074 654695 659287 542747 603239 778156 479087 541246 552783 755723 427183 799672 792510 692172 590693 470955 485589 476426 533648 542370 470535 509853 474488 590375 446314 543982 723074 819767 628181 590631 797799 470611 708134 557945 462717 474007 500625 781264 559644 709295 469890 426712 543677 793915 649094 462539 474036 545642 466002 470529 575420 384878 470391 443926 470620 792493 548905 523877 809765 473969 522662 474923 504268 490261 554563 522523 770788 754644 794247 524613 510427 454129 470675 544177 567388 397766 453651 478553 542765 555688 479108 410090 618236 802018 460781 559716 462329 454137 479092 490307 611723 730210 742046 470579 492690 694639 614698 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (2.41%) |
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 384878 392109 397766 397895 401049 410090 426712 427183 443132 443926 446314 450577 453625 453651 454129 454137 460781 462329 462539 462717 466002 469890 470391 470508 470529 470535 470579 470611 470620 470675 470678 470955 473969 474007 474036 474488 474923 476426 478553 479087 479092 479108 482489 485589 490261 490307 492690 492697 500625 504268 504295 509853 510427 510747 522523 522662 523877 524613 533648 534074 534132 541246 542370 542747 542765 543677 543760 543982 544177 545642 548900 548905 552783 554563 555688 556432 557937 557945 559644 559716 563400 567388 575420 590375 590631 590693 603239 611723 614698 618236 628181 649094 649266 654695 659287 673533 692172 694639 708134 709295 723074 730210 733830 742046 754644 755723 770788 778156 781264 792493 792510 793915 794247 797799 799672 802018 805368 809184 809765 819767 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian amateur threesome"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск любительск секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
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.