Query Metrics
7
Database Queries
7
Different statements
136.05 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.93 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.09 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny-teen pov"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.93 ms |
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 446685 468433 472567 579353 492459 695145 581025 588818 597450 461220 732033 458202 553031 598199 419914 468771 527975 520460 519558 525432 551130 542516 676956 577323 586573 602739 481149 476223 571834 437726 528034 576731 463628 488872 515842 553096 588071 420587 519563 596526 591187 596677 614747 568558 427263 560189 575783 584887 572019 610605 596168 619783 625675 469601 420635 524555 444938 437518 465817 446897 577540 597956 465991 443215 449450 456546 575104 426139 534707 553992 557236 603813 600535 624131 524542 428020 428035 558566 420878 517176 506445 560188 564456 565105 ] |
||||||||||||||||||||||||||||||
| 4 | 2.95 ms |
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 419914 420587 420635 420878 426139 427263 428020 428035 437518 437726 443215 444938 446685 446897 449450 456546 458202 461220 463628 465817 465991 468433 468771 469601 472567 476223 481149 488872 492459 506445 515842 517176 519558 519563 520460 524542 524555 525432 527975 528034 534707 542516 551130 553031 553096 553992 557236 558566 560188 560189 564456 565105 568558 571834 572019 575104 575783 576731 577323 577540 579353 581025 584887 586573 588071 588818 591187 596168 596526 596677 597450 597956 598199 600535 602739 603813 610605 614747 619783 624131 625675 676956 695145 732033 ] |
||||||||||||||||||||||||||||||
| 5 | 109.89 ms |
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 419914 420587 420635 420878 426139 427263 428020 428035 437518 437726 443215 444938 446685 446897 449450 456546 458202 461220 463628 465817 465991 468433 468771 469601 472567 476223 481149 488872 492459 506445 515842 517176 519558 519563 520460 524542 524555 525432 527975 528034 534707 542516 551130 553031 553096 553992 557236 558566 560188 560189 564456 565105 568558 571834 572019 575104 575783 576731 577323 577540 579353 581025 584887 586573 588071 588818 591187 596168 596526 596677 597450 597956 598199 600535 602739 603813 610605 614747 619783 624131 625675 676956 695145 732033 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen пов"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.59 ms |
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.