Query Metrics
7
Database Queries
7
Different statements
180.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.67 ms (86.34%) |
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 9974 187349 188453 188669 346150 370715 382284 383722 385408 388792 390165 391917 397305 397853 397923 420505 430602 433434 439530 444145 451121 463852 465708 466954 469483 469556 471764 472365 474855 485267 496935 501529 506334 509808 510413 513846 516474 518839 519088 520943 523023 523196 524114 526733 528157 529250 532817 536212 541230 542202 542787 544468 547936 549650 550354 558287 559142 559216 559346 563198 563414 569398 571028 573763 576669 578300 580608 581013 581231 583496 583732 587266 589681 590288 590370 592489 596891 598113 604403 604456 604923 607630 620150 624803 663281 664841 667314 668639 670274 670676 673124 681857 689715 690783 720925 721712 727996 729091 737404 737561 744277 744369 748529 749255 757276 757445 765657 767247 774881 776404 796644 803543 803775 804146 805808 806391 812981 815104 816785 827269 ] |
||||||||||||||||||||||||||||||
|
13.69 ms (7.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 757276 803543 744277 765657 542787 466954 607630 472365 385408 397853 528157 474855 558287 549650 496935 510413 390165 581013 188453 420505 578300 370715 592489 604923 524114 523023 526733 516474 559216 596891 624803 720925 620150 529250 563414 433434 583496 804146 776404 729091 744369 583732 664841 544468 573763 187349 383722 430602 589681 346150 668639 542202 451121 471764 547936 388792 550354 812981 188669 563198 532817 519088 581231 571028 559142 518839 9974 587266 774881 523196 469556 559346 670274 598113 520943 509808 439530 485267 501529 681857 590288 397923 727996 816785 469483 541230 690783 569398 444145 391917 382284 397305 506334 513846 827269 673124 689715 721712 667314 580608 803775 737404 805808 806391 576669 670676 465708 604456 663281 815104 463852 536212 590370 604403 737561 796644 767247 748529 757445 749255 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.85%) |
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 9974 187349 188453 188669 346150 370715 382284 383722 385408 388792 390165 391917 397305 397853 397923 420505 430602 433434 439530 444145 451121 463852 465708 466954 469483 469556 471764 472365 474855 485267 496935 501529 506334 509808 510413 513846 516474 518839 519088 520943 523023 523196 524114 526733 528157 529250 532817 536212 541230 542202 542787 544468 547936 549650 550354 558287 559142 559216 559346 563198 563414 569398 571028 573763 576669 578300 580608 581013 581231 583496 583732 587266 589681 590288 590370 592489 596891 598113 604403 604456 604923 607630 620150 624803 663281 664841 667314 668639 670274 670676 673124 681857 689715 690783 720925 721712 727996 729091 737404 737561 744277 744369 748529 749255 757276 757445 765657 767247 774881 776404 796644 803543 803775 804146 805808 806391 812981 815104 816785 827269 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелая чулки наездниц…"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин чулк нижн бел наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
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.