Query Metrics
7
Database Queries
7
Different statements
225.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.91 ms (86.90%) |
1 |
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 97096 382105 386016 387709 387895 403880 408974 415087 420142 420527 426128 427362 429288 429603 435737 438763 451583 453505 458222 460317 461876 469233 472107 472343 472678 475673 476818 486893 488707 489431 491711 492815 495482 497581 500202 501079 501774 504995 505239 506873 507095 509558 511334 512066 518380 519811 522809 523960 525955 527309 529039 542910 543021 547328 550423 551178 551909 551921 555099 555790 555996 559026 561894 566579 568307 569861 570213 570288 570353 570586 570611 571898 572107 572381 572439 572765 572812 573566 573817 574628 576545 577381 577455 583975 585477 586381 586424 589169 591675 610626 614244 614328 620645 626145 630777 645893 666868 667002 668690 671817 682573 702613 719097 728232 750976 751138 755460 758606 761466 770293 800198 800661 805149 805366 807493 809519 810681 810992 816261 818591 ] |
||||||||||||||||||||||||||||||
|
18.09 ms (8.02%) |
1 |
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 577381 543021 570213 570288 571898 572381 555790 570586 668690 682573 570353 572439 620645 591675 589169 810681 810992 505239 486893 522809 509558 568307 577455 435737 818591 476818 501079 547328 570611 572107 583975 719097 702613 614244 586381 800661 809519 755460 761466 770293 758606 807493 438763 387895 420527 518380 491711 504995 495482 382105 408974 497581 523960 97096 529039 555996 550423 573566 645893 671817 415087 453505 469233 472343 488707 666868 489431 667002 551921 427362 751138 387709 403880 472678 460317 555099 559026 572765 573817 574628 585477 610626 805366 429603 461876 472107 500202 458222 525955 527309 569861 586424 501774 507095 551909 512066 551178 511334 386016 426128 816261 475673 492815 519811 572812 542910 561894 566579 576545 626145 614328 630777 800198 805149 750976 728232 451583 420142 429288 506873 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (1.50%) |
1 |
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 97096 382105 386016 387709 387895 403880 408974 415087 420142 420527 426128 427362 429288 429603 435737 438763 451583 453505 458222 460317 461876 469233 472107 472343 472678 475673 476818 486893 488707 489431 491711 492815 495482 497581 500202 501079 501774 504995 505239 506873 507095 509558 511334 512066 518380 519811 522809 523960 525955 527309 529039 542910 543021 547328 550423 551178 551909 551921 555099 555790 555996 559026 561894 566579 568307 569861 570213 570288 570353 570586 570611 571898 572107 572381 572439 572765 572812 573566 573817 574628 576545 577381 577455 583975 585477 586381 586424 589169 591675 610626 614244 614328 620645 626145 630777 645893 666868 667002 668690 671817 682573 702613 719097 728232 750976 751138 755460 758606 761466 770293 800198 800661 805149 805366 807493 809519 810681 810992 816261 818591 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public agen sexy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на agen улиц sexy"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на agen улиц sexy"
]
|
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.