Query Metrics
7
Database Queries
7
Different statements
224.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.82 ms (88.55%) |
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 397503 401177 408330 416613 432288 433086 433204 433232 434443 439020 441027 441039 441081 446874 447160 452577 454039 454081 456226 456229 462384 467970 478489 487191 503166 503406 514879 515490 518083 519816 524675 525039 530809 536251 542802 545602 547496 551114 554280 561189 561743 564593 567952 568500 574924 575601 576920 586664 596638 597476 598053 598553 600128 601519 603362 622400 628397 629540 649960 652613 654922 661411 662049 663224 674959 675001 685417 693502 696103 696923 720128 720278 722171 722225 722229 722560 725608 725645 726273 728368 733041 733875 739237 740245 740335 744225 747362 747523 748927 749740 755925 761462 763839 765266 765424 768353 769016 769837 773910 775721 776233 776281 779773 786736 786872 790133 790958 793334 793899 794916 798639 799786 803378 803383 806046 806101 807642 810300 813437 ] |
||||||||||||||||||||||||||||||
|
15.82 ms (7.05%) |
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 776281 779773 790133 793334 799786 803383 786736 790958 761462 773910 786872 798639 813437 726273 733041 739237 725645 747362 747523 769016 763839 696923 720128 775721 794916 803378 810300 408330 536251 674959 433204 462384 447160 452577 515490 519816 518083 575601 576920 622400 603362 441081 439020 456226 456229 487191 675001 649960 441039 514879 567952 551114 806101 728368 446874 530809 568500 685417 661411 720278 722560 598053 776233 806046 765424 768353 725608 744225 807642 503166 769837 401177 454039 545602 597476 628397 434443 433086 454081 503406 432288 433232 416613 467970 574924 542802 561743 693502 586664 600128 598553 596638 740335 601519 478489 397503 497468 525039 524675 554280 654922 662049 696103 722225 722229 652613 663224 722171 793899 733875 748927 740245 755925 749740 629540 441027 564593 547496 561189 765266 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.17%) |
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 397503 401177 408330 416613 432288 433086 433204 433232 434443 439020 441027 441039 441081 446874 447160 452577 454039 454081 456226 456229 462384 467970 478489 487191 503166 503406 514879 515490 518083 519816 524675 525039 530809 536251 542802 545602 547496 551114 554280 561189 561743 564593 567952 568500 574924 575601 576920 586664 596638 597476 598053 598553 600128 601519 603362 622400 628397 629540 649960 652613 654922 661411 662049 663224 674959 675001 685417 693502 696103 696923 720128 720278 722171 722225 722229 722560 725608 725645 726273 728368 733041 733875 739237 740245 740335 744225 747362 747523 748927 749740 755925 761462 763839 765266 765424 768353 769016 769837 773910 775721 776233 776281 779773 786736 786872 790133 790958 793334 793899 794916 798639 799786 803378 803383 806046 806101 807642 810300 813437 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen ass hole"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen жоп дырк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen жоп дырк"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.73%) |
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.