Query Metrics
7
Database Queries
7
Different statements
156.37 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.77 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.87 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real ukrainian homemade"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.06 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 439770 530001 523301 498656 519859 506794 528262 551847 440693 439813 504141 557953 666530 601852 433380 460535 421810 421831 439808 418145 433371 439697 513498 527706 519512 448773 439764 462123 490841 527341 439621 620411 544386 557946 750701 459319 437960 597015 504450 718798 436703 421878 451639 523840 473139 601363 608336 584857 623089 438018 503617 598172 549569 400491 470302 422155 439749 446894 433323 518622 523171 567024 415836 481580 525224 506677 621239 601906 589450 584236 625437 526951 625983 730798 547612 549736 625440 603933 601851 597148 593366 623405 621764 ] |
||||||||||||||||||||||||||||||
| 4 | 3.07 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 400491 415836 418145 421810 421831 421878 422155 433323 433371 433380 436703 437960 438018 439621 439697 439749 439764 439770 439808 439813 440693 446894 448773 451639 459319 460535 462123 470302 473139 481580 490841 498656 503617 504141 504450 506677 506794 513498 518622 519512 519859 523171 523301 523840 525224 526951 527341 527706 528262 530001 544386 547612 549569 549736 551847 557946 557953 567024 584236 584857 589450 593366 597015 597148 598172 601363 601851 601852 601906 603933 608336 620411 621239 621764 623089 623405 625437 625440 625983 666530 718798 730798 750701 ] |
||||||||||||||||||||||||||||||
| 5 | 130.66 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 400491 415836 418145 421810 421831 421878 422155 433323 433371 433380 436703 437960 438018 439621 439697 439749 439764 439770 439808 439813 440693 446894 448773 451639 459319 460535 462123 470302 473139 481580 490841 498656 503617 504141 504450 506677 506794 513498 518622 519512 519859 523171 523301 523840 525224 526951 527341 527706 528262 530001 544386 547612 549569 549736 551847 557946 557953 567024 584236 584857 589450 593366 597015 597148 598172 601363 601851 601852 601906 603933 608336 620411 621239 621764 623089 623405 625437 625440 625983 666530 718798 730798 750701 ] |
||||||||||||||||||||||||||||||
| 6 | 1.39 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real русск домашн любительск"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.54 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real русск домашн любительск"
]
|
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.