Query Metrics
7
Database Queries
7
Different statements
432.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
224.06 ms (51.84%) |
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 183506 473921 493778 491583 446244 796143 386913 490783 563084 562147 519309 391740 396993 815529 817889 827648 583190 563401 667743 710833 621682 604488 779558 802459 807600 727482 751560 752010 762383 765255 768385 327121 660442 796075 811844 390582 432708 516730 531303 786120 213573 409938 814428 824195 454533 455640 458383 453234 513132 555279 666196 714911 564188 800497 765517 790206 795163 248347 454930 473005 504664 618861 482254 535447 446533 497686 532781 471666 661915 618344 470425 523847 423837 815866 816050 472857 529713 710265 703554 565715 588895 621310 799802 761743 767272 766537 739613 766767 615516 710559 716192 660067 759907 558894 442612 383418 391928 432735 432736 439071 454535 448874 468708 511510 504668 534557 548307 564545 707556 555258 618847 785856 799960 728465 761066 810359 188242 421844 391614 421917 ] |
||||||||||||||||||||||||||||||
|
199.15 ms (46.08%) |
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 183506 188242 213573 248347 327121 383418 386913 390582 391614 391740 391928 396993 409938 421844 421917 423837 432708 432735 432736 439071 442612 446244 446533 448874 453234 454533 454535 454930 455640 458383 468708 470425 471666 472857 473005 473921 482254 490783 491583 493778 497686 504664 504668 511510 513132 516730 519309 523847 529713 531303 532781 534557 535447 548307 555258 555279 558894 562147 563084 563401 564188 564545 565715 583190 588895 604488 615516 618344 618847 618861 621310 621682 660067 660442 661915 666196 667743 703554 707556 710265 710559 710833 714911 716192 727482 728465 739613 751560 752010 759907 761066 761743 762383 765255 765517 766537 766767 767272 768385 779558 785856 786120 790206 795163 796075 796143 799802 799960 800497 802459 807600 810359 811844 814428 815529 815866 816050 817889 824195 827648 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (0.58%) |
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 183506 188242 213573 248347 327121 383418 386913 390582 391614 391740 391928 396993 409938 421844 421917 423837 432708 432735 432736 439071 442612 446244 446533 448874 453234 454533 454535 454930 455640 458383 468708 470425 471666 472857 473005 473921 482254 490783 491583 493778 497686 504664 504668 511510 513132 516730 519309 523847 529713 531303 532781 534557 535447 548307 555258 555279 558894 562147 563084 563401 564188 564545 565715 583190 588895 604488 615516 618344 618847 618861 621310 621682 660067 660442 661915 666196 667743 703554 707556 710265 710559 710833 714911 716192 727482 728465 739613 751560 752010 759907 761066 761743 762383 765255 765517 766537 766767 767272 768385 779558 785856 786120 790206 795163 796075 796143 799802 799960 800497 802459 807600 810359 811844 814428 815529 815866 816050 817889 824195 827648 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал milf shower"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.35%) |
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.