Query Metrics
7
Database Queries
7
Different statements
188.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.39 ms (85.19%) |
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 384829 399647 416007 416685 416832 418117 418128 418158 418594 418641 418671 423315 423382 431396 434368 435562 444378 446686 449319 450739 451106 454641 460382 461664 473535 484268 502774 522935 526501 555292 564078 595339 597845 600171 607963 608003 618326 619167 627409 627472 635270 637191 637903 647854 656317 657197 668305 669946 672850 682932 686138 692743 714083 716229 722059 727483 728916 738460 741217 741222 742067 748637 750895 751705 755741 756627 756786 756950 758981 759436 761535 763922 765221 766157 770254 771623 773055 773056 773076 773464 775227 776083 778230 778808 780038 780333 782651 783939 784862 785073 785109 785113 785117 785780 785966 786575 787332 795024 796365 797036 797060 801560 801628 803040 803619 806597 807010 808262 808674 808785 808988 809626 810082 810281 812326 814014 815742 815899 825058 828348 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (8.76%) |
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 416007 686138 806597 775227 773056 770254 418128 399647 815899 795024 763922 810281 564078 449319 451106 672850 714083 780038 755741 741222 751705 773076 778808 785073 807010 759436 484268 473535 522935 597845 619167 741217 809626 434368 618326 555292 416832 783939 595339 635270 761535 418671 460382 668305 803619 778230 756786 797060 692743 780333 814014 815742 748637 785117 758981 773055 637903 418594 418641 627409 657197 627472 776083 785780 812326 738460 784862 771623 773464 766157 785109 787332 808674 828348 756627 785113 716229 608003 526501 801560 418158 384829 825058 722059 785966 797036 808988 808785 765221 647854 600171 796365 416685 454641 461664 502774 656317 803040 756950 423315 418117 423382 431396 444378 446686 682932 786575 801628 808262 742067 750895 727483 607963 782651 435562 450739 637191 810082 728916 669946 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (1.89%) |
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 384829 399647 416007 416685 416832 418117 418128 418158 418594 418641 418671 423315 423382 431396 434368 435562 444378 446686 449319 450739 451106 454641 460382 461664 473535 484268 502774 522935 526501 555292 564078 595339 597845 600171 607963 608003 618326 619167 627409 627472 635270 637191 637903 647854 656317 657197 668305 669946 672850 682932 686138 692743 714083 716229 722059 727483 728916 738460 741217 741222 742067 748637 750895 751705 755741 756627 756786 756950 758981 759436 761535 763922 765221 766157 770254 771623 773055 773056 773076 773464 775227 776083 778230 778808 780038 780333 782651 783939 784862 785073 785109 785113 785117 785780 785966 786575 787332 795024 796365 797036 797060 801560 801628 803040 803619 806597 807010 808262 808674 808785 808988 809626 810082 810281 812326 814014 815742 815899 825058 828348 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls squirt"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк сквирт оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.96%) |
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.