Query Metrics
7
Database Queries
7
Different statements
143.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.40 ms (85.70%) |
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 68464 73571 326043 382933 388857 392558 402206 402515 412493 487434 507848 510433 521252 521808 527586 530894 536729 540028 559207 567978 575351 577717 582059 585228 592834 613351 613949 616600 619813 625534 627012 627530 628829 629172 637970 639555 640320 642457 646579 646676 650913 651338 652641 652706 653686 661606 670309 678228 686999 688494 690528 695915 696391 699865 701008 705208 707228 708325 712078 717755 717824 717868 730941 732895 734805 734811 735388 738721 740186 747644 748629 750512 752062 758924 762008 762334 764205 766497 767309 768921 778342 778818 780084 780628 783949 784541 787683 787772 788694 788913 789896 789939 792036 793128 796445 797378 797453 797601 799398 799468 799838 801575 804293 805018 810152 810667 812079 812919 812933 813881 813885 817428 818288 818644 821832 822259 824083 825807 ] |
||||||||||||||||||||||||||||||
|
10.80 ms (7.50%) |
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 707228 686999 585228 797378 766497 767309 412493 813881 813885 822259 705208 652641 653686 712078 616600 642457 592834 627012 627530 796445 805018 784541 758924 734811 768921 787772 73571 392558 402515 540028 575351 650913 717824 688494 717868 696391 613949 780084 734805 740186 738721 629172 799468 68464 787683 817428 821832 717755 735388 748629 778818 527586 510433 818288 818644 487434 536729 530894 651338 708325 613351 789896 799398 792036 730941 762008 762334 763782 783949 788694 789939 797601 801575 812079 382933 326043 824083 521252 507848 567978 646579 646676 652706 699865 661606 701008 678228 640320 628829 639555 810152 812919 750512 747644 732895 764205 625534 627511 778342 797453 388857 825807 559207 577717 799838 752062 637970 788913 402206 521808 582059 670309 690528 695915 619813 804293 780628 812933 793128 810667 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.95%) |
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 68464 73571 326043 382933 388857 392558 402206 402515 412493 487434 507848 510433 521252 521808 527586 530894 536729 540028 559207 567978 575351 577717 582059 585228 592834 613351 613949 616600 619813 625534 627012 627530 628829 629172 637970 639555 640320 642457 646579 646676 650913 651338 652641 652706 653686 661606 670309 678228 686999 688494 690528 695915 696391 699865 701008 705208 707228 708325 712078 717755 717824 717868 730941 732895 734805 734811 735388 738721 740186 747644 748629 750512 752062 758924 762008 762334 764205 766497 767309 768921 778342 778818 780084 780628 783949 784541 787683 787772 788694 788913 789896 789939 792036 793128 796445 797378 797453 797601 799398 799468 799838 801575 804293 805018 810152 810667 812079 812919 812933 813881 813885 817428 818288 818644 821832 822259 824083 825807 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"college girls"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"college девушк"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"college девушк"
]
|
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.