Query Metrics
7
Database Queries
7
Different statements
151.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.03 ms (83.27%) |
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 395550 395985 400019 405709 422024 423426 424995 425356 432782 433040 435069 439271 443593 443644 444608 445256 447859 452965 454840 455471 456523 458053 458302 459539 460263 465195 467143 467186 467188 471474 474264 475267 481131 483594 484792 486171 489093 489120 492672 493033 493281 501295 507008 515779 517391 519492 522268 525349 543745 548594 554758 560903 565065 565286 565838 576139 577849 584913 587477 594874 597600 598557 598783 601266 603435 605698 611603 618361 620116 620121 621648 624975 627409 627625 630806 640891 651731 654299 656660 673128 682502 689315 689634 689693 698972 703193 712959 718223 719703 730928 732822 737465 739187 744368 744381 761553 761603 761611 761633 761637 765684 766687 768879 775239 777168 780060 780650 782123 782179 782187 787075 787491 789675 790464 798908 805347 806715 808781 809825 817507 ] |
||||||||||||||||||||||||||||||
|
16.17 ms (10.68%) |
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 712959 782187 730928 744381 790464 798908 761611 732822 465195 689315 761637 809825 519492 654299 423426 507008 560903 439271 719703 682502 718223 640891 761633 782123 780060 486171 395550 405709 517391 565065 597600 444608 515779 501295 618361 775239 766687 739187 445256 484792 422024 577849 576139 689693 698972 703193 782179 806715 761603 761553 744368 737465 777168 467188 611603 522268 627625 620121 587477 565286 454840 425356 789675 467143 447859 584913 489093 673128 780650 805347 768879 627409 424995 459539 554758 621648 601266 787075 455471 471474 435069 594874 605698 548594 400019 543745 598783 598557 432782 565838 620116 493033 458053 630806 624975 395985 689634 433040 443593 443644 460263 467186 481131 603435 651731 525349 475267 787491 474264 492672 656660 458302 493281 483594 456523 489120 817507 452965 765684 808781 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.80%) |
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 395550 395985 400019 405709 422024 423426 424995 425356 432782 433040 435069 439271 443593 443644 444608 445256 447859 452965 454840 455471 456523 458053 458302 459539 460263 465195 467143 467186 467188 471474 474264 475267 481131 483594 484792 486171 489093 489120 492672 493033 493281 501295 507008 515779 517391 519492 522268 525349 543745 548594 554758 560903 565065 565286 565838 576139 577849 584913 587477 594874 597600 598557 598783 601266 603435 605698 611603 618361 620116 620121 621648 624975 627409 627625 630806 640891 651731 654299 656660 673128 682502 689315 689634 689693 698972 703193 712959 718223 719703 730928 732822 737465 739187 744368 744381 761553 761603 761611 761633 761637 765684 766687 768879 775239 777168 780060 780650 782123 782179 782187 787075 787491 789675 790464 798908 805347 806715 808781 809825 817507 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen hidden"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen скрыт"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen скрыт"
]
|
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.