Query Metrics
7
Database Queries
7
Different statements
199.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.69 ms (88.43%) |
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 210768 282652 382594 388424 389093 393331 396235 396501 397425 401139 401558 401946 404695 409249 420384 420621 424908 425474 429901 447656 448375 451254 452625 453773 454603 455822 455855 467953 472450 474487 477742 483814 485715 489648 494072 494174 503117 506518 513484 514721 522861 524002 531290 538026 545765 552535 554192 554892 556474 559581 563333 563969 565166 566858 569981 572891 573191 573202 579394 584709 593207 599400 612039 614237 614292 618923 619012 628115 652274 660999 661287 666661 671032 672038 672938 685389 685479 685818 690896 690913 694062 697258 699695 703070 703086 703535 712786 713486 717849 729929 730418 741591 743131 744284 745912 747129 747503 750123 755030 757636 760012 761157 770304 786458 787563 792871 793219 794783 802491 811649 817009 819053 821071 821436 821942 822260 822441 823306 824580 827533 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (6.89%) |
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 743131 524002 425474 661287 397425 503117 483814 787563 599400 401946 584709 485715 404695 559581 672938 793219 573202 690896 792871 703070 401139 429901 506518 569981 619012 612039 448375 566858 671032 396235 455822 494072 618923 409249 556474 755030 685818 451254 514721 452625 712786 554192 420621 472450 717849 388424 393331 396501 401558 823306 821436 822260 573191 703086 628115 786458 760012 741591 757636 545765 747129 424908 572891 389093 489648 552535 563333 382594 822441 821942 827533 817009 821071 824580 538026 666661 672038 690913 652274 660999 697258 802491 730418 744284 750123 703535 729929 761157 531290 713486 699695 554892 614237 794783 747503 745912 770304 614292 477742 453773 447656 685479 210768 513484 819053 694062 811649 593207 494174 685389 474487 579394 455855 282652 420384 454603 522861 467953 563969 565166 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.42%) |
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 210768 282652 382594 388424 389093 393331 396235 396501 397425 401139 401558 401946 404695 409249 420384 420621 424908 425474 429901 447656 448375 451254 452625 453773 454603 455822 455855 467953 472450 474487 477742 483814 485715 489648 494072 494174 503117 506518 513484 514721 522861 524002 531290 538026 545765 552535 554192 554892 556474 559581 563333 563969 565166 566858 569981 572891 573191 573202 579394 584709 593207 599400 612039 614237 614292 618923 619012 628115 652274 660999 661287 666661 671032 672038 672938 685389 685479 685818 690896 690913 694062 697258 699695 703070 703086 703535 712786 713486 717849 729929 730418 741591 743131 744284 745912 747129 747503 750123 755030 757636 760012 761157 770304 786458 787563 792871 793219 794783 802491 811649 817009 819053 821071 821436 821942 822260 822441 823306 824580 827533 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на teen улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на teen улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.