Query Metrics
7
Database Queries
7
Different statements
148.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.02 ms (83.62%) |
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 154675 382476 385107 386193 389541 391917 391944 392839 395634 400950 401768 402632 414094 416539 416707 423781 424613 432945 441040 443251 443317 444485 445950 454793 466739 471126 471129 475497 477502 477506 480255 483749 494529 494532 500333 505093 511858 511864 511866 512072 516676 523362 524675 526902 529595 529714 530368 531578 531850 531856 537269 540945 541507 545453 564271 565036 567120 573268 574656 580832 584871 586999 587291 593274 595622 596252 596389 602329 602885 609887 619710 621562 625780 625785 625797 627194 638674 643159 644386 648960 650246 658816 660394 662046 668305 671020 684500 688181 689010 689775 701238 705571 717520 717542 722381 730060 745092 745111 745915 747325 749672 752630 752669 752682 760596 768508 782108 783261 784236 784701 787290 788027 791880 796939 803582 807112 808742 809000 811700 813205 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (10.00%) |
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 564271 580832 389541 385107 529595 537269 494532 684500 619710 627194 784236 782108 760596 705571 791880 483749 391917 424613 511858 466739 477506 625780 416539 565036 596252 730060 768508 783261 595622 701238 689010 573268 523362 526902 529714 530368 545453 541507 540945 660394 671020 658816 668305 593274 586999 602329 809000 745092 784701 745111 752669 752682 745915 747325 749672 752630 401768 471126 480255 796939 494529 402632 444485 787290 382476 400950 423781 475497 511866 531856 524675 531850 574656 688181 717542 689775 717520 722381 644386 609887 811700 813205 803582 807112 392839 386193 788027 648960 650246 602885 621562 625797 625785 395634 154675 391944 416707 443317 414094 441040 432945 443251 477502 454793 512072 511864 500333 531578 505093 516676 662046 567120 587291 808742 471129 445950 584871 596389 638674 643159 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.97%) |
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 154675 382476 385107 386193 389541 391917 391944 392839 395634 400950 401768 402632 414094 416539 416707 423781 424613 432945 441040 443251 443317 444485 445950 454793 466739 471126 471129 475497 477502 477506 480255 483749 494529 494532 500333 505093 511858 511864 511866 512072 516676 523362 524675 526902 529595 529714 530368 531578 531850 531856 537269 540945 541507 545453 564271 565036 567120 573268 574656 580832 584871 586999 587291 593274 595622 596252 596389 602329 602885 609887 619710 621562 625780 625785 625797 627194 638674 643159 644386 648960 650246 658816 660394 662046 668305 671020 684500 688181 689010 689775 701238 705571 717520 717542 722381 730060 745092 745111 745915 747325 749672 752630 752669 752682 760596 768508 782108 783261 784236 784701 787290 788027 791880 796939 803582 807112 808742 809000 811700 813205 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur dildo"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.