Query Metrics
7
Database Queries
7
Different statements
187.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.07 ms (84.97%) |
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 411236 422262 422282 426374 448427 456505 457859 462064 469625 470400 477067 483576 485382 488475 495444 501322 506468 508210 511199 512060 515984 523281 535515 544613 545294 553433 554960 556075 557098 574328 575950 581181 583534 589314 589660 591913 592061 592066 602177 603404 607396 620012 628625 632735 655132 660090 665770 666068 667914 668276 668713 683330 697194 705152 710091 710814 710837 714564 714848 715485 715935 718042 719923 720193 720624 724486 726081 728623 730163 731009 733577 736360 737883 738852 742251 742560 742824 744082 748642 752732 752760 755132 761137 761302 765791 767630 768388 773463 785035 788302 789455 793223 794173 794717 795301 795372 796002 800293 800953 801368 801920 804526 807304 807915 807964 811232 814672 814727 814922 815444 815810 815839 818009 819346 819410 820023 823956 824598 827491 827842 ] |
||||||||||||||||||||||||||||||
|
15.83 ms (8.45%) |
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 824598 827491 819346 820023 815444 815810 823956 483576 501322 511199 515984 535515 488475 544613 575950 557098 554960 574328 668713 710091 714564 660090 697194 710837 714848 715935 655132 718042 556075 581181 592066 602177 620012 589314 603404 628625 632735 589660 591913 592061 793223 800953 804526 807964 796002 801920 724486 728623 730163 737883 752732 755132 785035 788302 789455 794717 801368 807304 811232 726081 731009 733577 736360 748642 752760 767630 768388 742560 761302 773463 742824 744082 765791 738852 742251 607396 710814 794173 795301 795372 807915 477067 523281 485382 422282 448427 495444 506468 720624 800293 761137 512060 426374 411236 422262 814922 814727 819410 814672 815839 818009 827842 457859 470400 456505 469625 462064 508210 545294 583534 553433 665770 683330 715485 719923 667914 668276 705152 720193 666068 ] |
||||||||||||||||||||||||||||||
|
4.48 ms (2.40%) |
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 411236 422262 422282 426374 448427 456505 457859 462064 469625 470400 477067 483576 485382 488475 495444 501322 506468 508210 511199 512060 515984 523281 535515 544613 545294 553433 554960 556075 557098 574328 575950 581181 583534 589314 589660 591913 592061 592066 602177 603404 607396 620012 628625 632735 655132 660090 665770 666068 667914 668276 668713 683330 697194 705152 710091 710814 710837 714564 714848 715485 715935 718042 719923 720193 720624 724486 726081 728623 730163 731009 733577 736360 737883 738852 742251 742560 742824 744082 748642 752732 752760 755132 761137 761302 765791 767630 768388 773463 785035 788302 789455 793223 794173 794717 795301 795372 796002 800293 800953 801368 801920 804526 807304 807915 807964 811232 814672 814727 814922 815444 815810 815839 818009 819346 819410 820023 823956 824598 827491 827842 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf inside"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf inside"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf inside"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.