Query Metrics
7
Database Queries
7
Different statements
136.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.09 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ukrainian real sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.63 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 528262 448773 561273 418145 574566 598133 497923 786552 557946 574833 718798 474776 475873 541084 546015 490996 504141 750701 422151 587886 473139 503617 525953 504450 635074 436703 440693 421878 437960 465075 439813 451639 527341 568961 605698 551847 459319 421922 462569 446894 438018 623089 557042 597015 601982 608336 584857 549569 422155 433323 601991 400491 523840 470302 439749 518622 598172 457789 567024 620411 601363 621239 618943 523171 601906 730798 415836 584236 589450 474663 497921 625983 526951 549736 597148 601851 620124 625437 547612 603933 623405 593366 625440 621764 ] |
||||||||||||||||||||||||||||||
| 4 | 3.39 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 421878 421922 422151 422155 433323 436703 437960 438018 439749 439813 440693 446894 448773 451639 457789 459319 462569 465075 470302 473139 474663 474776 475873 490996 497921 497923 503617 504141 504450 518622 523171 523840 525953 526951 527341 528262 541084 546015 547612 549569 549736 551847 557042 557946 561273 567024 568961 574566 574833 584236 584857 587886 589450 593366 597015 597148 598133 598172 601363 601851 601906 601982 601991 603933 605698 608336 618943 620124 620411 621239 621764 623089 623405 625437 625440 625983 635074 718798 730798 750701 786552 ] |
||||||||||||||||||||||||||||||
| 5 | 105.69 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 421878 421922 422151 422155 433323 436703 437960 438018 439749 439813 440693 446894 448773 451639 457789 459319 462569 465075 470302 473139 474663 474776 475873 490996 497921 497923 503617 504141 504450 518622 523171 523840 525953 526951 527341 528262 541084 546015 547612 549569 549736 551847 557042 557946 561273 567024 568961 574566 574833 584236 584857 587886 589450 593366 597015 597148 598133 598172 601363 601851 601906 601982 601991 603933 605698 608336 618943 620124 620411 621239 621764 623089 623405 625437 625440 625983 635074 718798 730798 750701 786552 ] |
||||||||||||||||||||||||||||||
| 6 | 1.44 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск real секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 3.13 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.