Query Metrics
7
Database Queries
7
Different statements
148.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.91 ms (83.59%) |
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 61726 130016 386700 386759 387033 390389 395549 396961 401137 401270 405116 412914 417874 421784 423319 432872 444591 449894 450312 459338 459350 461126 463159 464640 468545 468741 471141 472250 477242 489288 492933 504185 514004 526613 528774 531435 539071 545484 557974 558065 559584 569531 577594 590852 601928 607454 607574 607667 608033 618656 619647 626293 634416 636638 638181 641138 641921 641965 654225 665781 685263 692471 704233 717313 717820 717974 722914 736631 740053 755348 756319 756589 760182 765403 769502 770105 770520 770930 777017 780737 781862 782155 784550 784788 788818 793662 793683 795522 796237 797461 798344 798703 798872 800016 800470 800492 802445 802631 802671 804178 804594 804800 805694 805737 806907 808531 808537 810000 810249 813431 813559 813920 814887 814983 814986 815714 817238 818903 821195 ] |
||||||||||||||||||||||||||||||
|
14.60 ms (9.85%) |
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 802445 740053 793683 808531 810000 802671 804800 805737 760182 577594 421784 444591 423319 638181 793662 504185 539071 717313 654225 618656 810249 607574 770520 390389 396961 769502 780737 805694 813559 557974 685263 781862 770930 804178 417874 815714 814986 814983 531435 634416 608033 704233 395549 817238 802631 800470 717820 405116 607667 601928 61726 818903 526613 722914 784788 717974 528774 808537 770105 472250 806907 401137 813920 619647 636638 804594 784828 795522 813431 784550 796237 800016 755348 782155 432872 798703 692471 386759 463159 641921 590852 736631 777017 471141 607454 401270 459338 468741 477242 130016 821195 798344 765403 450312 468545 386700 412914 514004 545484 800492 797461 387033 665781 814887 449894 459350 464640 489288 558065 569531 559584 626293 756319 756589 641138 788818 798872 461126 492933 641965 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.88%) |
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 61726 130016 386700 386759 387033 390389 395549 396961 401137 401270 405116 412914 417874 421784 423319 432872 444591 449894 450312 459338 459350 461126 463159 464640 468545 468741 471141 472250 477242 489288 492933 504185 514004 526613 528774 531435 539071 545484 557974 558065 559584 569531 577594 590852 601928 607454 607574 607667 608033 618656 619647 626293 634416 636638 638181 641138 641921 641965 654225 665781 685263 692471 704233 717313 717820 717974 722914 736631 740053 755348 756319 756589 760182 765403 769502 770105 770520 770930 777017 780737 781862 782155 784550 784788 788818 793662 793683 795522 796237 797461 798344 798703 798872 800016 800470 800492 802445 802631 802671 804178 804594 804800 805694 805737 806907 808531 808537 810000 810249 813431 813559 813920 814887 814983 814986 815714 817238 818903 821195 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"curvy blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"curvy минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"curvy минет оральн секс"
]
|
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.