Query Metrics
7
Database Queries
7
Different statements
146.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.97 ms (82.60%) |
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 419064 421146 429770 443476 447150 447152 453356 476753 478973 497874 508175 510397 511254 512453 523856 530493 530627 531127 531157 531163 531207 531210 531211 531256 533463 533557 534650 534985 534992 535597 536227 536608 536681 536686 536693 537209 537928 539239 540408 541197 541201 542583 542588 542590 542591 542595 544833 545441 565245 565253 565264 565266 565277 583132 597232 597237 597242 597269 599917 599945 599990 600194 600329 601514 610577 628082 628364 628381 628391 628403 634145 634158 634186 634786 634787 640733 647949 649214 649215 649504 649509 649556 650158 650174 656507 656568 656574 656577 666523 666879 674943 674952 675001 676020 676023 676024 676066 677295 677781 678067 678161 680190 695126 696606 708444 733838 733843 733849 733863 733866 733867 733877 733879 733881 733883 733895 733908 733909 748931 756405 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (10.85%) |
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 666879 597242 597269 733877 733866 453356 530493 510397 649509 531207 534992 531256 656507 708444 600329 733849 533557 675001 536227 733838 756405 544833 476753 676024 429770 677295 666523 628403 650158 531127 656577 733881 733883 733863 733843 634786 508175 497874 530627 531210 540408 531211 597237 601514 628364 733895 640733 536686 674943 478973 565245 419064 534650 542591 565266 649504 649214 599917 512453 634158 565277 531157 535597 583132 599990 733908 733909 656574 647949 676066 565264 628381 733867 748931 680190 536681 539239 534985 537209 541201 650174 634145 634787 443476 421146 533463 511254 676023 695126 610577 628391 447152 447150 536608 542583 542590 542588 542595 678067 678161 649215 565253 599945 634186 600194 733879 523856 676020 628082 531163 536693 537928 656568 649556 597232 696606 545441 541197 674952 677781 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.73%) |
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 419064 421146 429770 443476 447150 447152 453356 476753 478973 497874 508175 510397 511254 512453 523856 530493 530627 531127 531157 531163 531207 531210 531211 531256 533463 533557 534650 534985 534992 535597 536227 536608 536681 536686 536693 537209 537928 539239 540408 541197 541201 542583 542588 542590 542591 542595 544833 545441 565245 565253 565264 565266 565277 583132 597232 597237 597242 597269 599917 599945 599990 600194 600329 601514 610577 628082 628364 628381 628391 628403 634145 634158 634186 634786 634787 640733 647949 649214 649215 649504 649509 649556 650158 650174 656507 656568 656574 656577 666523 666879 674943 674952 675001 676020 676023 676024 676066 677295 677781 678067 678161 680190 695126 696606 708444 733838 733843 733849 733863 733866 733867 733877 733879 733881 733883 733895 733908 733909 748931 756405 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dap anal teen"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dap анал teen"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dap анал teen"
]
|
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.