Query Metrics
7
Database Queries
7
Different statements
193.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.08 ms (87.78%) |
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 62010 187567 188338 358592 358596 382434 383124 385359 387997 389500 390045 391076 391574 391579 391653 391704 394204 394420 395933 397865 398209 398531 398550 398560 398950 403320 403924 406556 406978 407790 407809 407819 409200 409201 409346 409937 410958 411330 411341 411360 411769 424478 443703 445920 447837 453096 454208 454886 460923 462327 462562 464326 467484 470201 473829 474479 476237 476338 477718 485775 487340 491412 500422 503580 505690 512593 518863 518871 518874 520141 520867 522486 523572 526208 528158 546113 546119 554542 567342 610031 614523 617781 667543 669436 726468 726480 726484 726491 726518 726527 726530 726531 726542 726552 726558 726561 726691 726702 726718 726876 727022 728239 731194 731775 733405 737167 740183 742656 742811 742860 743834 748143 748337 750773 750782 756815 758425 766582 766618 806311 ] |
||||||||||||||||||||||||||||||
|
13.89 ms (7.17%) |
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 737167 748337 750782 766582 766618 726468 726484 726527 726530 726531 726542 726552 726558 726561 726702 726876 728239 731775 733405 740183 742656 743834 758425 726518 726691 742860 750773 756815 726480 726491 727022 731194 742811 614523 806311 187567 383124 391653 394204 395933 407790 409201 410958 443703 476338 188338 394420 397865 409346 411330 358592 385359 391579 391704 398531 403320 409937 411341 411360 398560 398950 406556 409200 411769 462327 424478 445920 528158 500422 518863 491412 512593 476237 447837 520141 487340 667543 669436 748143 398550 391076 518874 464326 389500 453096 382434 358596 470201 387997 406978 610031 617781 726718 62010 462562 391574 390045 398209 403924 407809 407819 467484 454208 454886 460923 473829 474479 477718 520867 518871 523572 526208 503580 505690 522486 485775 546113 554542 567342 546119 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.51%) |
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 62010 187567 188338 358592 358596 382434 383124 385359 387997 389500 390045 391076 391574 391579 391653 391704 394204 394420 395933 397865 398209 398531 398550 398560 398950 403320 403924 406556 406978 407790 407809 407819 409200 409201 409346 409937 410958 411330 411341 411360 411769 424478 443703 445920 447837 453096 454208 454886 460923 462327 462562 464326 467484 470201 473829 474479 476237 476338 477718 485775 487340 491412 500422 503580 505690 512593 518863 518871 518874 520141 520867 522486 523572 526208 528158 546113 546119 554542 567342 610031 614523 617781 667543 669436 726468 726480 726484 726491 726518 726527 726530 726531 726542 726552 726558 726561 726691 726702 726718 726876 727022 728239 731194 731775 733405 737167 740183 742656 742811 742860 743834 748143 748337 750773 750782 756815 758425 766582 766618 806311 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old chubby mature"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old chubby mature"
]
|
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.