Query Metrics
7
Database Queries
7
Different statements
159.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.70 ms (84.36%) |
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 5565 10077 69440 82289 152655 197442 322187 350980 383323 384853 391036 391482 392095 395793 397777 398274 399563 401805 402816 403400 404385 407335 409001 417304 418067 419988 420096 427799 445672 446402 455769 457671 459700 461250 461267 461670 462248 462518 462960 470115 474928 475012 477573 480935 495268 497610 501240 502066 506217 512651 521989 522585 523139 529067 529556 539425 548604 550447 551196 551313 551521 554016 557036 563458 565156 567743 568315 570301 570435 571547 574785 587595 587886 590667 593635 595859 598168 600311 601967 603873 606810 608448 610618 611645 613268 616709 621449 623149 625239 632280 652197 659650 661547 676205 690468 694368 705030 708010 709269 719214 722181 723017 727515 732890 743567 757040 760206 764893 764961 768338 771387 774819 780245 786787 787554 787611 792193 805357 817384 819221 ] |
||||||||||||||||||||||||||||||
|
15.31 ms (9.59%) |
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 819221 574785 613268 568315 551521 571547 446402 587886 557036 529556 501240 445672 587595 610618 694368 350980 418067 764893 771387 727515 69440 397777 419988 197442 567743 550447 401805 521989 551313 817384 593635 768338 764961 565156 661547 705030 621449 420096 757040 611645 603873 392095 480935 780245 652197 409001 82289 554016 787554 5565 601967 616709 805357 743567 398274 600311 787611 774819 723017 595859 632280 786787 470115 475012 548604 659650 690468 399563 732890 383323 462248 403400 570435 529067 523139 719214 590667 539425 502066 606810 462518 459700 461670 395793 10077 474928 522585 455769 457671 676205 708010 598168 608448 625239 722181 563458 384853 322187 391036 152655 461267 623149 570301 427799 404385 462960 407335 461250 709269 760206 512651 792193 477573 551196 417304 495268 497610 506217 402816 391482 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.92%) |
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 5565 10077 69440 82289 152655 197442 322187 350980 383323 384853 391036 391482 392095 395793 397777 398274 399563 401805 402816 403400 404385 407335 409001 417304 418067 419988 420096 427799 445672 446402 455769 457671 459700 461250 461267 461670 462248 462518 462960 470115 474928 475012 477573 480935 495268 497610 501240 502066 506217 512651 521989 522585 523139 529067 529556 539425 548604 550447 551196 551313 551521 554016 557036 563458 565156 567743 568315 570301 570435 571547 574785 587595 587886 590667 593635 595859 598168 600311 601967 603873 606810 608448 610618 611645 613268 616709 621449 623149 625239 632280 652197 659650 661547 676205 690468 694368 705030 708010 709269 719214 722181 723017 727515 732890 743567 757040 760206 764893 764961 768338 771387 774819 780245 786787 787554 787611 792193 805357 817384 819221 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс красивая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.90%) |
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.