Query Metrics
7
Database Queries
7
Different statements
141.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.71 ms (82.68%) |
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 81734 385053 386226 388424 397960 398740 413388 415855 427722 429799 430559 436132 443113 444069 447150 447337 452805 453495 453583 457217 461100 462922 463840 465070 468171 468482 473066 475508 478542 479818 480854 481943 483307 485350 489310 490953 492072 493535 498112 499856 500290 502242 502797 503861 505138 505345 509833 510516 511372 511489 513569 514254 515364 515559 516339 518766 520489 520491 521431 521829 523503 524094 528104 530166 530249 531403 535621 538395 544439 546083 546854 547235 550633 555089 556476 556483 581083 588689 590263 590696 592500 593867 596226 596632 596799 600269 614968 620231 629333 629630 632794 635224 639782 645230 648583 651161 652915 656913 664431 666470 671083 673797 695893 696154 699718 717924 721106 721992 728540 742224 743455 745918 754902 778393 814270 815559 816547 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (10.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 728540 742224 743455 745918 754902 620231 778393 480854 388424 453495 485350 492072 523503 530166 397960 415855 443113 413388 462922 463840 481943 505138 521431 500290 652915 546083 593867 614968 436132 430559 453583 468171 509833 505345 483307 490953 502242 518766 498112 520491 530249 479818 556483 635224 444069 473066 521829 581083 656913 664431 447337 538395 596799 81734 429799 457217 493535 447150 465070 468482 516339 511489 478542 550633 648583 596226 629333 632794 590263 629630 461100 475508 511372 535621 489310 520489 513569 386226 385053 398740 427722 814270 818387 819565 821409 815559 816547 452805 515364 524094 499856 502797 503861 514254 528104 515559 510516 531403 544439 547235 546854 555089 556476 666470 695893 645230 671083 696154 721106 721992 651161 673797 699718 717924 588689 592500 596632 590696 600269 639782 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.90%) |
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 81734 385053 386226 388424 397960 398740 413388 415855 427722 429799 430559 436132 443113 444069 447150 447337 452805 453495 453583 457217 461100 462922 463840 465070 468171 468482 473066 475508 478542 479818 480854 481943 483307 485350 489310 490953 492072 493535 498112 499856 500290 502242 502797 503861 505138 505345 509833 510516 511372 511489 513569 514254 515364 515559 516339 518766 520489 520491 521431 521829 523503 524094 528104 530166 530249 531403 535621 538395 544439 546083 546854 547235 550633 555089 556476 556483 581083 588689 590263 590696 592500 593867 596226 596632 596799 600269 614968 620231 629333 629630 632794 635224 639782 645230 648583 651161 652915 656913 664431 666470 671083 673797 695893 696154 699718 717924 721106 721992 728540 742224 743455 745918 754902 778393 814270 815559 816547 818387 819565 821409 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock dildo"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock дилд"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock дилд"
]
|
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.