Query Metrics
7
Database Queries
7
Different statements
114.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.67 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.26 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"the wild sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.56 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 492670 823198 553071 601637 453806 526133 528074 554468 570381 477187 509590 501713 524633 438748 504297 528775 536335 466490 534627 625729 440680 554462 562269 560272 447452 522859 491380 419590 596462 439777 522901 528202 476225 524712 814865 518265 612431 631616 509439 431540 627745 442785 533350 635136 520037 582531 606494 473963 610577 504769 476752 484818 508156 522911 528641 640805 445015 561375 598863 492760 606571 572385 510591 472299 513426 488246 653219 615718 421353 523162 651148 519390 545755 570223 702163 570306 484498 569841 599041 568555 646448 513951 478651 ] |
||||||||||||||||||||||||||||||
| 4 | 2.93 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 419590 421353 431540 438748 439777 440680 442785 445015 447452 453806 466490 472299 473963 476225 476752 477187 478651 484498 484818 488246 491380 492670 492760 501713 504297 504769 508156 509439 509590 510591 513426 513951 518265 519390 520037 522859 522901 522911 523162 524633 524712 526133 528074 528202 528641 528775 533350 534627 536335 545755 553071 554462 554468 560272 561375 562269 568555 569841 570223 570306 570381 572385 582531 596462 598863 599041 601637 606494 606571 610577 612431 615718 625729 627745 631616 635136 640805 646448 651148 653219 702163 814865 823198 ] |
||||||||||||||||||||||||||||||
| 5 | 87.45 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 419590 421353 431540 438748 439777 440680 442785 445015 447452 453806 466490 472299 473963 476225 476752 477187 478651 484498 484818 488246 491380 492670 492760 501713 504297 504769 508156 509439 509590 510591 513426 513951 518265 519390 520037 522859 522901 522911 523162 524633 524712 526133 528074 528202 528641 528775 533350 534627 536335 545755 553071 554462 554468 560272 561375 562269 568555 569841 570223 570306 570381 572385 582531 596462 598863 599041 601637 606494 606571 610577 612431 615718 625729 627745 631616 635136 640805 646448 651148 653219 702163 814865 823198 ] |
||||||||||||||||||||||||||||||
| 6 | 1.72 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"wild секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.52 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"wild секс"
]
|
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.