Query Metrics
7
Database Queries
7
Different statements
168.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.32 ms (84.31%) |
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 34593 187786 194033 233353 338022 386172 387021 387285 388722 388792 390923 392576 394338 396862 397456 397917 400134 400199 401933 404175 407903 417238 418862 418956 420410 426940 428113 432662 432663 435700 440836 443357 445238 451826 454306 455218 456408 460262 461035 461598 461859 465312 466793 472162 475452 476337 485460 486533 491583 504837 507427 509933 510108 513510 516501 521999 526738 529249 541068 556661 557499 562975 564385 569146 591893 600888 618549 624288 630292 630840 631607 637400 650136 665080 677258 678491 680441 691196 691199 697009 697203 714884 716484 727016 727032 727673 737079 737082 748209 748218 753204 761326 770018 771355 776521 781914 784306 788173 788610 795415 800681 801338 803078 803295 803327 807539 807695 807716 807724 807733 808167 808175 808176 808239 811174 811952 813918 818814 820762 823909 ] |
||||||||||||||||||||||||||||||
|
15.94 ms (9.45%) |
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 390923 678491 428113 803078 807724 803295 811174 801338 466793 397917 823909 691199 417238 697203 737079 727673 808175 386172 803327 753204 811952 807695 807733 788610 737082 233353 394338 714884 426940 400134 418862 818814 387021 529249 650136 387285 665080 194033 397456 807716 407903 788173 761326 808167 388792 34593 677258 432663 476337 807539 485460 813918 187786 400199 491583 562975 631607 776521 727016 618549 475452 781914 440836 630840 800681 396862 569146 680441 748209 455218 521999 795415 392576 461598 432662 564385 784306 748218 507427 716484 338022 445238 820762 808176 526738 454306 727032 435700 557499 624288 461859 770018 388722 504837 591893 630292 472162 516501 451826 513510 460262 637400 509933 541068 697009 600888 808239 771355 691196 456408 404175 465312 443357 418956 510108 420410 556661 401933 486533 461035 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.36%) |
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 34593 187786 194033 233353 338022 386172 387021 387285 388722 388792 390923 392576 394338 396862 397456 397917 400134 400199 401933 404175 407903 417238 418862 418956 420410 426940 428113 432662 432663 435700 440836 443357 445238 451826 454306 455218 456408 460262 461035 461598 461859 465312 466793 472162 475452 476337 485460 486533 491583 504837 507427 509933 510108 513510 516501 521999 526738 529249 541068 556661 557499 562975 564385 569146 591893 600888 618549 624288 630292 630840 631607 637400 650136 665080 677258 678491 680441 691196 691199 697009 697203 714884 716484 727016 727032 727673 737079 737082 748209 748218 753204 761326 770018 771355 776521 781914 784306 788173 788610 795415 800681 801338 803078 803295 803327 807539 807695 807716 807724 807733 808167 808175 808176 808239 811174 811952 813918 818814 820762 823909 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother creampie young"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин creampie young"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин creampie young"
]
|
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.