Query Metrics
7
Database Queries
7
Different statements
153.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.65 ms (83.07%) |
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 388545 392107 411469 412627 419998 427053 427148 429696 438296 438957 444952 445425 446787 449377 452215 454133 465428 466005 468509 469468 470621 470674 477129 491125 491187 495498 495499 499493 507631 508797 509019 511580 513623 515976 517430 523627 525139 526656 530404 533700 533712 535371 535378 535381 535407 535409 535601 536082 539318 540691 543644 543751 543951 548049 553644 555047 558686 571792 574076 578010 579079 579587 590410 598390 602885 619902 627668 650064 655295 655479 664595 669886 669902 669923 687113 710350 711716 714319 714322 714332 714336 714346 714496 719475 725489 732169 734860 736036 745335 754531 762171 766381 778521 778695 779837 779861 780938 782119 791955 792740 803233 803239 804389 804836 804838 805615 806762 807236 810328 813921 816163 819935 824850 825515 825791 825797 825800 826357 827460 827556 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (10.08%) |
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 419998 495498 495499 574076 579079 429696 438957 539318 803233 826357 827460 827556 523627 530404 511580 517430 687113 710350 553644 598390 602885 627668 779837 782119 805615 779861 804838 807236 734860 754531 725489 810328 491187 711716 791955 762171 427053 465428 714332 745335 466005 571792 590410 411469 446787 388545 452215 449377 558686 579587 412627 454133 509019 499493 555047 444952 525139 825791 470621 655479 468509 445425 470674 526656 508797 438296 813921 540691 655295 669923 714496 669886 619902 806762 778695 804389 804836 736036 778521 780938 507631 491125 803239 578010 427148 792740 469468 513623 477129 543644 548049 650064 766381 515976 714319 664595 714336 714346 714322 732169 392107 825515 819935 816163 824850 825797 825800 533712 535409 536082 533700 535371 535601 535407 535378 535381 543951 543751 719475 669902 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.94%) |
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 388545 392107 411469 412627 419998 427053 427148 429696 438296 438957 444952 445425 446787 449377 452215 454133 465428 466005 468509 469468 470621 470674 477129 491125 491187 495498 495499 499493 507631 508797 509019 511580 513623 515976 517430 523627 525139 526656 530404 533700 533712 535371 535378 535381 535407 535409 535601 536082 539318 540691 543644 543751 543951 548049 553644 555047 558686 571792 574076 578010 579079 579587 590410 598390 602885 619902 627668 650064 655295 655479 664595 669886 669902 669923 687113 710350 711716 714319 714322 714332 714336 714346 714496 719475 725489 732169 734860 736036 745335 754531 762171 766381 778521 778695 779837 779861 780938 782119 791955 792740 803233 803239 804389 804836 804838 805615 806762 807236 810328 813921 816163 819935 824850 825515 825791 825797 825800 826357 827460 827556 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf solo russian"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf соло русск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.99%) |
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.