Query Metrics
7
Database Queries
7
Different statements
151.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.52 ms (82.06%) |
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 401837 406377 415866 422051 424871 427262 443122 448317 451870 453900 454950 455600 455935 458699 460741 465358 465365 465760 468077 469326 476454 479570 485349 485622 486542 487131 489597 490945 492652 497209 500526 502907 503220 505526 506471 512172 513220 513434 514621 516108 518207 518300 518828 521382 522666 524247 527258 527922 534574 537732 544489 545642 552372 555969 558221 570544 570691 575089 575464 576079 578835 580103 580225 583835 584793 586671 587918 588264 597258 597900 598071 600007 600276 603716 605278 610819 612914 614568 619450 619705 621374 628582 632018 640892 648840 653496 663521 666704 672817 675066 675104 675107 675127 675139 679003 681031 681046 695183 705528 719067 719887 727334 729999 730250 735704 735871 738766 740309 748256 751512 755212 759563 760202 762848 793662 802119 808075 809215 809516 815594 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.82%) |
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 663521 672817 675127 570544 575089 580103 580225 583835 588264 614568 619705 632018 597258 597900 612914 619450 621374 586671 610819 605278 809516 729999 735704 760202 793662 808075 738766 727334 740309 762848 735871 751512 705528 802119 809215 469326 479570 460741 465365 465760 455600 476454 458699 465358 415866 443122 448317 468077 503220 527258 506471 524247 485622 489597 492652 518207 485349 487131 490945 497209 502907 512172 514621 516108 518828 401837 406377 424871 422051 427262 815594 451870 454950 455935 453900 486542 500526 513434 518300 527922 537732 505526 521382 534574 513220 522666 575464 584793 552372 555969 544489 545642 570691 648840 666704 675107 681031 695183 719887 653496 719067 675066 675104 675139 679003 681046 558221 576079 578835 600007 600276 628582 587918 598071 640892 603716 730250 748256 759563 755212 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.10%) |
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 401837 406377 415866 422051 424871 427262 443122 448317 451870 453900 454950 455600 455935 458699 460741 465358 465365 465760 468077 469326 476454 479570 485349 485622 486542 487131 489597 490945 492652 497209 500526 502907 503220 505526 506471 512172 513220 513434 514621 516108 518207 518300 518828 521382 522666 524247 527258 527922 534574 537732 544489 545642 552372 555969 558221 570544 570691 575089 575464 576079 578835 580103 580225 583835 584793 586671 587918 588264 597258 597900 598071 600007 600276 603716 605278 610819 612914 614568 619450 619705 621374 628582 632018 640892 648840 653496 663521 666704 672817 675066 675104 675107 675127 675139 679003 681031 681046 695183 705528 719067 719887 727334 729999 730250 735704 735871 738766 740309 748256 751512 755212 759563 760202 762848 793662 802119 808075 809215 809516 815594 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy slut"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy slut"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy slut"
]
|
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.