Query Metrics
7
Database Queries
7
Different statements
152.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.39 ms (82.34%) |
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 538824 538913 539503 541419 541599 541626 544310 544591 546447 547930 553278 557991 558001 558785 559063 559064 560924 562961 563001 563125 563155 563157 563188 563196 563204 563210 563217 563427 563442 567394 567397 567420 567431 567436 567751 568261 573763 576641 576671 577385 581348 581359 585088 589659 589739 592472 592518 592535 593310 593402 596415 597018 603225 603489 604977 604985 605308 615726 617807 620159 620172 621682 621717 622316 622823 629409 629936 644315 649105 651217 654092 668985 670109 671725 671758 672184 681085 690827 690853 690865 690885 691518 692805 693032 694089 694135 694222 694441 694464 695188 695247 696240 696322 696350 696553 698590 699592 699594 699744 699745 700660 702367 703097 703512 703523 708438 716071 717607 719107 722212 726657 733118 734375 740097 770130 790393 811940 813115 817278 819506 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (10.95%) |
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 576671 671758 691518 694222 695188 695247 696240 696350 719107 722212 651217 671725 672184 654092 690865 690885 694441 702367 592472 592535 622316 593402 603489 622823 589739 604985 790393 734375 740097 604977 617807 700660 563217 567420 567751 562961 615726 541419 560924 817278 539503 538824 553278 544310 576641 544591 558785 563204 563210 581359 649105 690827 694135 696322 668985 670109 692805 693032 694089 694464 698590 699594 703097 703512 717607 681085 690853 696553 699592 703523 708438 716071 563157 563188 568261 644315 596415 621682 621717 629409 589659 597018 592518 593310 603225 605308 620159 620172 629936 813115 811940 770130 733118 726657 699744 699745 541626 585088 819506 538913 541599 563001 563125 559063 559064 563196 563442 567431 577385 546447 547930 558001 563155 573763 557991 563427 567394 567397 567436 581348 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.87%) |
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 538824 538913 539503 541419 541599 541626 544310 544591 546447 547930 553278 557991 558001 558785 559063 559064 560924 562961 563001 563125 563155 563157 563188 563196 563204 563210 563217 563427 563442 567394 567397 567420 567431 567436 567751 568261 573763 576641 576671 577385 581348 581359 585088 589659 589739 592472 592518 592535 593310 593402 596415 597018 603225 603489 604977 604985 605308 615726 617807 620159 620172 621682 621717 622316 622823 629409 629936 644315 649105 651217 654092 668985 670109 671725 671758 672184 681085 690827 690853 690865 690885 691518 692805 693032 694089 694135 694222 694441 694464 695188 695247 696240 696322 696350 696553 698590 699592 699594 699744 699745 700660 702367 703097 703512 703523 708438 716071 717607 719107 722212 726657 733118 734375 740097 770130 790393 811940 813115 817278 819506 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature vintage"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature vintage"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature vintage"
]
|
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.