Query Metrics
7
Database Queries
7
Different statements
203.76 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.55 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.97 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс час"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.23 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 519597 481557 624281 597158 499978 509727 566439 560368 493381 592403 454748 500899 557243 557125 474826 452677 497885 644849 590823 489240 570743 583654 550448 454439 458925 557926 668653 522647 569000 591016 606888 538676 596659 516763 522606 563014 550976 576706 606561 598852 470291 644025 385535 527676 578804 485098 516314 517187 564825 606571 615746 618230 445201 491392 569544 574460 687158 516764 516773 605988 462949 528794 652544 601529 612125 521495 604743 624151 618789 593832 541644 680195 553272 521135 613174 553942 523492 493204 600056 568062 542195 485454 658405 620205 ] |
||||||||||||||||||||||||||||||
| 4 | 2.38 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 385535 445201 452677 454439 454748 458925 462949 470291 474826 481557 485098 485454 489240 491392 493204 493381 497885 499978 500899 509727 516314 516763 516764 516773 517187 519597 521135 521495 522606 522647 523492 527676 528794 538676 541644 542195 550448 550976 553272 553942 557125 557243 557926 560368 563014 564825 566439 568062 569000 569544 570743 574460 576706 578804 583654 590823 591016 592403 593832 596659 597158 598852 600056 601529 604743 605988 606561 606571 606888 612125 613174 615746 618230 618789 620205 624151 624281 644025 644849 652544 658405 668653 680195 687158 ] |
||||||||||||||||||||||||||||||
| 5 | 179.37 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 385535 445201 452677 454439 454748 458925 462949 470291 474826 481557 485098 485454 489240 491392 493204 493381 497885 499978 500899 509727 516314 516763 516764 516773 517187 519597 521135 521495 522606 522647 523492 527676 528794 538676 541644 542195 550448 550976 553272 553942 557125 557243 557926 560368 563014 564825 566439 568062 569000 569544 570743 574460 576706 578804 583654 590823 591016 592403 593832 596659 597158 598852 600056 601529 604743 605988 606561 606571 606888 612125 613174 615746 618230 618789 620205 624151 624281 644025 644849 652544 658405 668653 680195 687158 ] |
||||||||||||||||||||||||||||||
| 6 | 1.73 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс час"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
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.