Query Metrics
7
Database Queries
7
Different statements
183.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.08 ms (84.92%) |
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 181397 261144 310295 320078 383774 384769 388856 395596 395805 395818 396662 398909 399688 401148 401621 403321 405690 407881 409179 410393 418865 419527 421592 424193 425653 430783 433473 436393 448527 448795 449358 458438 459134 459535 459642 459803 460226 464157 465143 465664 469487 470403 475780 478298 479856 480415 485125 486610 491061 491275 496565 498803 500339 504970 506406 517008 517013 519233 519268 519548 519652 519962 521819 522881 522923 525664 533645 534924 535535 535878 539319 543607 544120 556950 560920 563827 564765 583099 599203 609165 613432 614220 614993 621699 629428 634546 647602 647630 650846 666579 668509 671714 673772 674269 713574 717720 717839 750549 756103 761163 765817 770901 777003 777573 783392 785525 787272 787287 787863 789747 799290 799802 809421 809463 813945 814288 815388 815727 816502 825830 ] |
||||||||||||||||||||||||||||||
|
17.44 ms (9.49%) |
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 809421 750549 783392 809463 770901 761163 756103 765817 613432 777003 787272 395805 401621 403321 410393 424193 469487 407881 479856 383774 396662 401148 430783 261144 418865 425653 448795 459803 465664 480415 459642 465143 521819 500339 486610 519652 525664 504970 522923 433473 609165 519962 650846 421592 517013 539319 395818 448527 634546 395596 459535 629428 614993 506406 533645 543607 517008 583099 384769 458438 470403 485125 496565 498803 535535 478298 544120 563827 674269 556950 599203 388856 436393 459134 464157 399688 419527 460226 398909 449358 475780 519233 519268 522881 491061 491275 519548 181397 310295 320078 405690 409179 813945 825830 814288 815388 816502 815727 534924 535878 564765 647602 668509 647630 666579 713574 717839 671714 673772 717720 560920 614220 621699 777573 785525 787287 787863 799290 799802 789747 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.68%) |
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 181397 261144 310295 320078 383774 384769 388856 395596 395805 395818 396662 398909 399688 401148 401621 403321 405690 407881 409179 410393 418865 419527 421592 424193 425653 430783 433473 436393 448527 448795 449358 458438 459134 459535 459642 459803 460226 464157 465143 465664 469487 470403 475780 478298 479856 480415 485125 486610 491061 491275 496565 498803 500339 504970 506406 517008 517013 519233 519268 519548 519652 519962 521819 522881 522923 525664 533645 534924 535535 535878 539319 543607 544120 556950 560920 563827 564765 583099 599203 609165 613432 614220 614993 621699 629428 634546 647602 647630 650846 666579 668509 671714 673772 674269 713574 717720 717839 750549 756103 761163 765817 770901 777003 777573 783392 785525 787272 787287 787863 789747 799290 799802 809421 809463 813945 814288 815388 815727 816502 825830 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf beautiful anal"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf красивая анал"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.