Query Metrics
7
Database Queries
7
Different statements
159.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.50 ms (85.44%) |
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 86472 89021 385355 395442 397095 397398 405975 425301 434317 435365 437079 437444 443416 444780 444986 447508 456758 459379 460288 462139 462284 462822 465450 466232 466789 469601 470342 470822 471966 474050 476892 479410 482059 483445 483978 488381 490764 495048 500622 500634 501466 501690 502109 502372 503966 505876 507136 511475 513804 513806 515264 517116 522253 522331 524316 524816 526870 528481 528485 528516 530604 531361 532131 533815 534932 537983 538060 539432 542605 556460 558911 588842 595394 600042 602244 628801 633890 638505 641434 648497 657256 668097 676389 677581 695051 715292 715952 721255 721826 724814 726397 730166 730547 730738 731393 735307 736544 739290 740096 741665 743688 745723 745826 748453 749485 753935 758366 760868 762169 763803 779590 795602 797722 798277 811160 813058 820321 824568 825084 826240 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (8.91%) |
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 795602 501466 511475 532131 503966 515264 462284 745723 444780 460288 715292 721826 600042 735307 447508 470342 500622 462139 507136 534932 522253 533815 539432 502109 502372 513804 530604 537983 538060 542605 695051 641434 736544 395442 459379 528516 437079 435365 730738 741665 748453 89021 444986 528481 513806 465450 638505 724814 760868 797722 726397 385355 405975 476892 488381 482059 500634 501690 524316 531361 633890 740096 762169 753935 758366 443416 437444 474050 479410 397095 397398 456758 471966 466232 524816 517116 483978 490764 495048 505876 425301 824568 676389 677581 648497 657256 668097 715952 721255 556460 558911 588842 628801 595394 798277 813058 749485 811160 739290 743688 731393 526870 820321 826240 825084 763803 730547 745826 730166 779590 602244 434317 466789 528485 483445 462822 470822 522331 469601 86472 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.48%) |
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 86472 89021 385355 395442 397095 397398 405975 425301 434317 435365 437079 437444 443416 444780 444986 447508 456758 459379 460288 462139 462284 462822 465450 466232 466789 469601 470342 470822 471966 474050 476892 479410 482059 483445 483978 488381 490764 495048 500622 500634 501466 501690 502109 502372 503966 505876 507136 511475 513804 513806 515264 517116 522253 522331 524316 524816 526870 528481 528485 528516 530604 531361 532131 533815 534932 537983 538060 539432 542605 556460 558911 588842 595394 600042 602244 628801 633890 638505 641434 648497 657256 668097 676389 677581 695051 715292 715952 721255 721826 724814 726397 730166 730547 730738 731393 735307 736544 739290 740096 741665 743688 745723 745826 748453 749485 753935 758366 760868 762169 763803 779590 795602 797722 798277 811160 813058 820321 824568 825084 826240 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой член вебкам"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.89%) |
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.