Query Metrics
7
Database Queries
7
Different statements
208.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.62 ms (85.28%) |
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 146112 233269 233397 387377 389829 391380 397410 400463 400719 400817 401116 408429 418803 428867 430275 439572 439715 441001 441017 447492 454179 454232 454244 456341 464520 465791 467296 469905 470029 472764 477906 477994 478337 480957 490208 494536 496356 501442 504669 506042 510689 512041 518842 519492 523138 524664 526025 526594 533763 537985 545530 546002 546951 548655 549768 550233 553608 558417 560579 560594 561731 563063 563214 569983 570069 574815 574838 576127 586449 590224 594223 595873 596161 596616 597494 598069 598441 604147 605841 624487 654846 660300 664433 676951 678954 679378 695316 696324 701508 709588 714448 716543 722781 722823 722827 726892 744328 747008 747583 765891 784569 785337 789182 789874 794906 798992 800316 800535 805243 808192 809909 811611 812364 814562 821839 821846 821854 821856 821867 825867 ] |
||||||||||||||||||||||||||||||
|
19.41 ms (9.32%) |
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 518842 526594 523138 821839 678954 660300 784569 744328 747008 800316 789874 798992 789182 469905 512041 233269 400719 472764 506042 537985 821854 598069 605841 597494 812364 785337 722823 722827 811611 400463 501442 526025 550233 595873 545530 563063 558417 561731 389829 441001 464520 447492 465791 477994 430275 454232 519492 524664 490208 496356 821856 821846 560579 654846 679378 726892 576127 397410 696324 233397 825867 439715 439572 533763 546951 570069 716543 553608 563214 596161 809909 722781 794906 400817 387377 391380 401116 428867 480957 478337 510689 598441 408429 146112 596616 548655 549768 470029 477906 454244 441017 454179 494536 814562 821867 456341 467296 504669 569983 574838 560594 574815 664433 701508 676951 695316 546002 604147 586449 590224 594223 805243 800535 765891 747583 624487 709588 714448 808192 418803 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.46%) |
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 146112 233269 233397 387377 389829 391380 397410 400463 400719 400817 401116 408429 418803 428867 430275 439572 439715 441001 441017 447492 454179 454232 454244 456341 464520 465791 467296 469905 470029 472764 477906 477994 478337 480957 490208 494536 496356 501442 504669 506042 510689 512041 518842 519492 523138 524664 526025 526594 533763 537985 545530 546002 546951 548655 549768 550233 553608 558417 560579 560594 561731 563063 563214 569983 570069 574815 574838 576127 586449 590224 594223 595873 596161 596616 597494 598069 598441 604147 605841 624487 654846 660300 664433 676951 678954 679378 695316 696324 701508 709588 714448 716543 722781 722823 722827 726892 744328 747008 747583 765891 784569 785337 789182 789874 794906 798992 800316 800535 805243 808192 809909 811611 812364 814562 821839 821846 821854 821856 821867 825867 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian fuck young"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс young"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск секс young"
]
|
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.