Query Metrics
7
Database Queries
7
Different statements
139.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.36 ms (83.32%) |
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 392565 397897 400722 443930 444242 467789 467863 472605 495020 509571 604379 718650 723749 725247 725472 725483 725497 725539 726802 727584 728090 728832 730611 730766 731151 732956 735361 735828 735944 736381 736994 738290 738332 738355 739935 741088 741514 744167 746102 746188 746646 748550 748593 749443 750922 752570 753500 753659 754063 754466 755121 755167 757382 757924 758251 758296 760882 761399 762177 763870 764105 764109 765562 766260 766344 766437 767081 767514 768440 768447 769460 777869 778692 779265 781171 786601 788603 790340 791120 792538 792709 793146 794363 794406 794816 795310 795921 795927 795929 795947 795951 795964 795974 795987 795990 796408 799671 799674 799903 799920 800559 801445 801783 802051 802085 803882 807110 808320 810354 810463 811381 811776 811783 812468 812905 819751 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (9.24%) |
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 786601 788603 792538 794406 795987 795990 807110 777869 778692 781171 793146 794816 795310 795947 796408 799903 799920 800559 808320 723749 725247 725472 725483 727584 735944 741088 743671 744167 744936 750922 757924 764105 766260 790340 791120 792709 794363 795927 795964 799674 801783 802051 802085 811381 812905 730611 732956 735828 736381 748550 752570 762177 765562 766437 725497 731151 735361 738290 738332 738355 739935 748593 754063 754466 758251 760878 760882 725539 726802 730766 741514 746646 749443 753659 755121 755167 757382 764109 765549 767081 767514 768440 768447 769460 728090 728832 736994 746102 746188 753500 758296 761399 763870 766344 604379 718650 779265 795921 795929 795951 795974 799671 801445 803882 810354 810463 811776 811783 812468 392565 397897 467863 467789 509571 495020 400722 444242 443930 819751 472605 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (2.02%) |
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 392565 397897 400722 443930 444242 467789 467863 472605 495020 509571 604379 718650 723749 725247 725472 725483 725497 725539 726802 727584 728090 728832 730611 730766 731151 732956 735361 735828 735944 736381 736994 738290 738332 738355 739935 741088 741514 744167 746102 746188 746646 748550 748593 749443 750922 752570 753500 753659 754063 754466 755121 755167 757382 757924 758251 758296 760882 761399 762177 763870 764105 764109 765562 766260 766344 766437 767081 767514 768440 768447 769460 777869 778692 779265 781171 786601 788603 790340 791120 792538 792709 793146 794363 794406 794816 795310 795921 795927 795929 795947 795951 795964 795974 795987 795990 796408 799671 799674 799903 799920 800559 801445 801783 802051 802085 803882 807110 808320 810354 810463 811381 811776 811783 812468 812905 819751 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam milf russian"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер milf русск"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.09%) |
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.