Query Metrics
7
Database Queries
7
Different statements
153.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.07 ms (84.21%) |
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 382585 385832 388544 397464 398783 399952 403393 405707 411494 420677 420775 425322 426021 443769 444199 445948 449407 453524 453595 455409 455787 456023 458357 461230 461250 461489 461999 462170 462528 463737 466016 470101 470597 472106 473228 473761 474229 475012 477198 477449 478711 480094 482028 483242 483614 485640 488726 490786 491188 491367 491744 492153 497091 497871 498455 500403 500704 503753 506217 508546 509672 509764 510048 513408 514408 521872 521981 522796 523974 525883 533138 552079 560002 560469 561245 562165 565439 567830 573008 584424 589720 595888 596347 598145 598558 598591 598994 603948 617096 656044 657077 657603 658616 673170 676527 709295 720649 722855 723017 723599 741808 741989 742938 748437 754650 761471 761797 762076 764107 772588 777827 778761 779195 779300 781087 783162 787902 794945 796701 800231 ] |
||||||||||||||||||||||||||||||
|
14.11 ms (9.21%) |
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 482028 778761 761797 772588 509672 794945 455787 742938 561245 787902 513408 483242 779195 560002 426021 754650 584424 473761 411494 477449 598994 506217 723599 657603 420775 474229 461250 461489 462170 445948 514408 741989 617096 598145 461999 560469 598558 676527 473228 462528 388544 777827 478711 444199 603948 449407 509764 565439 523974 453524 596347 522796 463737 490786 552079 455409 470597 525883 521981 500704 658616 723017 657077 741808 475012 397464 398783 480094 382585 500403 491367 488726 709295 533138 783162 762076 420677 453595 779300 748437 562165 521872 656044 796701 761471 764107 781087 399952 466016 483614 498455 497871 503753 458357 403393 567830 573008 385832 461230 491744 405707 800231 722855 508546 497091 456023 425322 595888 472106 477198 510048 485640 491188 492153 443769 589720 470101 720649 673170 598591 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.63%) |
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 382585 385832 388544 397464 398783 399952 403393 405707 411494 420677 420775 425322 426021 443769 444199 445948 449407 453524 453595 455409 455787 456023 458357 461230 461250 461489 461999 462170 462528 463737 466016 470101 470597 472106 473228 473761 474229 475012 477198 477449 478711 480094 482028 483242 483614 485640 488726 490786 491188 491367 491744 492153 497091 497871 498455 500403 500704 503753 506217 508546 509672 509764 510048 513408 514408 521872 521981 522796 523974 525883 533138 552079 560002 560469 561245 562165 565439 567830 573008 584424 589720 595888 596347 598145 598558 598591 598994 603948 617096 656044 657077 657603 658616 673170 676527 709295 720649 722855 723017 723599 741808 741989 742938 748437 754650 761471 761797 762076 764107 772588 777827 778761 779195 779300 781087 783162 787902 794945 796701 800231 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет красотки русские"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс красивая русск"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.01%) |
1 |
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.