Query Metrics
7
Database Queries
7
Different statements
404.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.94 ms (51.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair milf anal"
]
|
||||||||||||||||||||||||||||||
|
175.99 ms (43.47%) |
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 12203 424933 429809 433375 434181 436937 439440 439634 439724 439791 439803 439806 439810 439821 440222 440276 447166 448084 448350 448735 449082 451624 452931 454303 454756 464210 466248 466258 468100 469582 470834 471813 480432 483644 490780 491164 497007 505815 510879 512770 519089 519444 523842 528327 530001 536424 537665 544754 555779 560949 561447 562881 563096 566685 590795 590823 591355 601930 603545 604269 604890 615511 618909 626887 626965 638991 646292 650388 669189 671049 680249 682358 695427 701763 707318 715896 716794 726897 730074 737522 742804 744651 746333 758766 758789 759908 759933 760877 761038 761200 761597 765580 766437 767273 770138 775477 779119 781824 785491 790009 790834 801083 802519 805271 807846 810363 812014 812829 813514 814218 816538 817293 817362 819005 820385 821187 822045 822206 822585 825571 ] |
||||||||||||||||||||||||||||||
|
12.65 ms (3.12%) |
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 604890 626887 590823 439634 439724 439810 439440 439791 439821 440222 464210 530001 491164 483644 512770 817293 814218 448735 449082 682358 707318 650388 544754 562881 615511 781824 802519 758766 758789 801083 813514 737522 746333 770138 742804 744651 759908 779119 807846 433375 439806 448084 528327 638991 626965 439803 480432 429809 819005 822585 816538 820385 821187 822045 822206 825571 519444 566685 555779 646292 701763 790009 812829 767273 810363 766437 761200 759933 761038 790834 436937 424933 440276 468100 448350 452931 497007 519089 536424 469582 561447 563096 669189 695427 680249 591355 730074 805271 765580 603545 716794 434181 454756 466248 470834 454303 466258 471813 447166 451624 505815 523842 537665 560949 671049 812014 761597 785491 510879 775477 12203 817362 490780 715896 601930 590795 604269 618909 726897 760877 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.56%) |
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 12203 424933 429809 433375 434181 436937 439440 439634 439724 439791 439803 439806 439810 439821 440222 440276 447166 448084 448350 448735 449082 451624 452931 454303 454756 464210 466248 466258 468100 469582 470834 471813 480432 483644 490780 491164 497007 505815 510879 512770 519089 519444 523842 528327 530001 536424 537665 544754 555779 560949 561447 562881 563096 566685 590795 590823 591355 601930 603545 604269 604890 615511 618909 626887 626965 638991 646292 650388 669189 671049 680249 682358 695427 701763 707318 715896 716794 726897 730074 737522 742804 744651 746333 758766 758789 759908 759933 760877 761038 761200 761597 765580 766437 767273 770138 775477 779119 781824 785491 790009 790834 801083 802519 805271 807846 810363 812014 812829 813514 814218 816538 817293 817362 819005 820385 821187 822045 822206 822585 825571 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair milf анал"
]
|
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.