Query Metrics
7
Database Queries
7
Different statements
223.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.11 ms (88.51%) |
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 341079 388175 437836 456115 466408 507097 513008 513364 524604 529701 532306 533164 535854 537507 547715 552692 563589 565588 567612 584364 585521 585586 588098 588460 589521 589633 592654 597754 601420 602070 602995 606555 619625 624932 626121 626288 626300 627619 631579 634412 636628 637798 644527 646421 652747 655900 656514 666890 671264 691182 691212 696128 707056 713999 724048 729308 733995 734903 739389 759249 761861 764062 764282 764433 764613 765313 765977 766659 766971 770030 771021 772551 773407 773736 775289 776289 777497 780763 780827 781458 783354 784425 785018 785559 785763 787821 788842 789474 789610 791422 791557 794112 794136 794875 797208 797355 797484 798834 799843 800772 800782 803055 803943 805209 806118 806217 806713 808237 808478 808495 808761 809826 809851 810422 812614 812975 817270 820857 822580 825889 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (6.69%) |
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 713999 655900 656514 666890 563589 627619 636628 588098 626300 602995 619625 631579 791557 794112 794875 797484 798834 806118 806713 808761 809851 780827 789474 799843 800772 806217 809826 773736 784425 789610 794136 803943 761861 764433 764282 766659 644527 787821 791422 797355 808237 507097 780763 766971 547715 808495 777497 765313 729308 646421 456115 812614 585521 724048 537507 707056 652747 691212 589633 626121 626288 775289 805209 783354 797208 808478 759249 773407 772551 637798 800782 764613 437836 671264 565588 589521 592654 634412 770030 764062 825889 606555 624932 588460 532306 552692 691182 781458 733995 739389 771021 513008 696128 388175 529701 533164 584364 567612 810422 812975 341079 822580 820857 535854 601420 803055 765977 466408 597754 524604 513364 817270 585586 602070 785763 785559 788842 734903 776289 785018 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.69%) |
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 341079 388175 437836 456115 466408 507097 513008 513364 524604 529701 532306 533164 535854 537507 547715 552692 563589 565588 567612 584364 585521 585586 588098 588460 589521 589633 592654 597754 601420 602070 602995 606555 619625 624932 626121 626288 626300 627619 631579 634412 636628 637798 644527 646421 652747 655900 656514 666890 671264 691182 691212 696128 707056 713999 724048 729308 733995 734903 739389 759249 761861 764062 764282 764433 764613 765313 765977 766659 766971 770030 771021 772551 773407 773736 775289 776289 777497 780763 780827 781458 783354 784425 785018 785559 785763 787821 788842 789474 789610 791422 791557 794112 794136 794875 797208 797355 797484 798834 799843 800772 800782 803055 803943 805209 806118 806217 806713 808237 808478 808495 808761 809826 809851 810422 812614 812975 817270 820857 822580 825889 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп пов"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass pov"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.72%) |
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.