Query Metrics
7
Database Queries
7
Different statements
202.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.43 ms (83.76%) |
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 383943 390922 401933 405891 410051 410642 412132 413595 416098 417177 417631 419132 419740 420587 420659 421494 422044 424321 425027 425799 425980 426459 427346 429985 430048 430422 437864 438278 443323 443652 445471 446337 448810 450318 452034 452144 453813 453918 458010 460771 464011 464139 464464 466230 466994 467025 471639 472513 473102 473539 477890 479196 480745 481895 482409 482674 483107 484719 489738 491078 491210 492269 493477 495230 495739 495835 497362 499028 501198 504417 506573 507601 507813 508492 508547 510588 511503 514587 514815 514949 515126 515183 516007 516103 521985 522212 532655 533846 534845 536744 537208 538207 544381 551736 557064 559181 559766 561816 562775 562803 565539 566082 567153 572029 573234 573314 580270 581095 588318 590910 591135 591314 593875 602017 603854 614074 618874 646255 675321 682096 ] |
||||||||||||||||||||||||||||||
|
23.35 ms (11.54%) |
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 484719 491210 506573 497362 501198 538207 448810 532655 536744 562803 646255 590910 445471 682096 508547 614074 420587 516103 390922 417631 425027 450318 537208 544381 561816 593875 437864 416098 510588 521985 551736 477890 427346 471639 430048 417177 472513 483107 489738 383943 405891 425799 443652 412132 413595 429985 453918 452144 446337 467025 504417 507601 514587 559766 565539 567153 559181 562775 464464 426459 466230 421494 491078 514949 515183 516007 511503 515126 602017 481895 591135 430422 492269 507813 533846 534845 410051 493477 508492 443323 438278 580270 458010 464139 572029 591314 603854 618874 424321 425980 482409 482674 464011 495739 495835 480745 581095 401933 410642 473102 495230 499028 522212 514815 479196 419132 452034 422044 566082 675321 573314 588318 419740 420659 466994 453813 473539 460771 557064 573234 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.21%) |
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 383943 390922 401933 405891 410051 410642 412132 413595 416098 417177 417631 419132 419740 420587 420659 421494 422044 424321 425027 425799 425980 426459 427346 429985 430048 430422 437864 438278 443323 443652 445471 446337 448810 450318 452034 452144 453813 453918 458010 460771 464011 464139 464464 466230 466994 467025 471639 472513 473102 473539 477890 479196 480745 481895 482409 482674 483107 484719 489738 491078 491210 492269 493477 495230 495739 495835 497362 499028 501198 504417 506573 507601 507813 508492 508547 510588 511503 514587 514815 514949 515126 515183 516007 516103 521985 522212 532655 533846 534845 536744 537208 538207 544381 551736 557064 559181 559766 561816 562775 562803 565539 566082 567153 572029 573234 573314 580270 581095 588318 590910 591135 591314 593875 602017 603854 614074 618874 646255 675321 682096 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"лижет две пизды"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза две вагин"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.78%) |
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.