Query Metrics
7
Database Queries
7
Different statements
159.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.89 ms (85.14%) |
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 44900 197736 233889 310683 359075 385632 387496 389629 395720 396317 396970 397223 397362 398345 398548 407072 411929 471887 478382 490193 502724 532125 533609 537985 540958 546883 561757 563064 566171 589022 590449 591111 591430 609157 620241 625567 663391 663882 663979 665498 665513 665515 666770 667593 667615 668730 668848 670481 697618 708125 710549 714818 716296 716487 718499 718550 718563 721413 724719 725341 728481 730550 731755 739173 741468 742695 742812 742879 744890 744906 746049 747949 748379 750878 752949 752975 755776 758429 765889 769905 770151 772513 774332 776742 779178 780614 781659 781666 781679 781692 781694 781757 782213 782284 785497 785931 788822 788877 789305 789363 789530 793918 794699 798067 800695 804216 807189 807608 811469 815629 815677 817401 818737 818921 820228 820280 823612 823710 823792 824145 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (9.01%) |
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 233889 396970 411929 533609 490193 502724 310683 44900 387496 397223 397362 398548 407072 815629 818921 820228 823612 820280 823710 824145 815677 818737 823792 817401 471887 537985 546883 540958 566171 563064 667593 668730 716487 721413 663391 665513 665515 668848 663979 666770 667615 670481 708125 716296 718499 718563 561757 590449 620241 591111 591430 609157 589022 776742 785931 788877 794699 779178 780614 781694 781757 782213 782284 789530 804216 811469 725341 748379 755776 772513 788822 789305 789363 800695 807189 807608 724719 741468 758429 730550 739173 742879 752949 752975 774332 742812 747949 750878 770151 728481 731755 744890 744906 746049 765889 769905 697618 710549 714818 718550 781659 781666 781679 781692 785497 793918 359075 197736 389629 398345 385632 396317 532125 665498 663882 625567 798067 742695 478382 395720 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.56%) |
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 44900 197736 233889 310683 359075 385632 387496 389629 395720 396317 396970 397223 397362 398345 398548 407072 411929 471887 478382 490193 502724 532125 533609 537985 540958 546883 561757 563064 566171 589022 590449 591111 591430 609157 620241 625567 663391 663882 663979 665498 665513 665515 666770 667593 667615 668730 668848 670481 697618 708125 710549 714818 716296 716487 718499 718550 718563 721413 724719 725341 728481 730550 731755 739173 741468 742695 742812 742879 744890 744906 746049 747949 748379 750878 752949 752975 755776 758429 765889 769905 770151 772513 774332 776742 779178 780614 781659 781666 781679 781692 781694 781757 782213 782284 785497 785931 788822 788877 789305 789363 789530 793918 794699 798067 800695 804216 807189 807608 811469 815629 815677 817401 818737 818921 820228 820280 823612 823710 823792 824145 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature old"
]
|
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.