Query Metrics
7
Database Queries
7
Different statements
161.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.65 ms (82.39%) |
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 392513 398715 402717 402967 403761 405913 419356 427060 428264 428484 436578 437341 438779 439920 449053 450389 454122 456327 457409 457410 460379 460897 462598 462969 462984 466555 466760 468178 470510 470616 470637 474053 477401 483156 484101 484827 484829 484831 484832 486925 497876 504281 504302 504463 512760 513752 515507 533326 534078 536840 541629 543971 544393 544725 545391 552677 558658 559738 560423 562288 562601 574131 576402 577739 578739 584214 586624 591393 596567 605251 606700 608160 609858 611505 621095 624045 634192 645093 646693 650277 653730 659276 667785 671338 676342 681053 686334 686845 692419 697555 701548 706457 707892 709309 713925 718881 727808 729626 731325 739863 742214 746079 757974 760698 762388 764017 775843 776022 782384 785238 785382 787780 787911 798249 802356 806103 806420 813544 821586 822645 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (10.94%) |
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 697555 659276 686845 562288 586624 608160 621095 591393 596567 611505 782384 787911 742214 762388 729626 609858 634192 775843 776022 438779 466555 403761 428264 439920 470616 462984 402717 456327 470510 484831 497876 504281 513752 484832 392513 437341 427060 449053 450389 457410 462969 468178 466760 470637 484829 483156 484827 533326 534078 504463 536840 474053 544725 558658 559738 574131 560423 562601 650277 686334 707892 713925 676342 706457 606700 624045 746079 757974 785238 727808 764017 731325 760698 787780 802356 457409 454122 460379 477401 436578 460897 462598 484101 486925 504302 515507 512760 398715 402967 428484 419356 822645 821586 577739 584214 545391 701548 718881 645093 671338 681053 692419 646693 653730 667785 578739 605251 806103 813544 739863 709309 785382 798249 405913 552677 541629 543971 544393 576402 806420 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (2.15%) |
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 392513 398715 402717 402967 403761 405913 419356 427060 428264 428484 436578 437341 438779 439920 449053 450389 454122 456327 457409 457410 460379 460897 462598 462969 462984 466555 466760 468178 470510 470616 470637 474053 477401 483156 484101 484827 484829 484831 484832 486925 497876 504281 504302 504463 512760 513752 515507 533326 534078 536840 541629 543971 544393 544725 545391 552677 558658 559738 560423 562288 562601 574131 576402 577739 578739 584214 586624 591393 596567 605251 606700 608160 609858 611505 621095 624045 634192 645093 646693 650277 653730 659276 667785 671338 676342 681053 686334 686845 692419 697555 701548 706457 707892 709309 713925 718881 727808 729626 731325 739863 742214 746079 757974 760698 762388 764017 775843 776022 782384 785238 785382 787780 787911 798249 802356 806103 806420 813544 821586 822645 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"party girls"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"party девушк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"party девушк"
]
|
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.