Query Metrics
7
Database Queries
7
Different statements
467.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
226.75 ms (48.50%) |
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 182118 390760 392687 400638 404028 409035 414122 414157 415758 415988 423837 424248 428174 428700 429900 432289 432656 437947 439558 440911 440944 441095 443243 443246 443257 444533 446610 452187 452937 455603 457217 458007 458761 460378 464971 465670 468165 470949 472835 477081 477757 478003 483523 486784 493411 493840 494481 494484 497905 500340 504777 510877 513672 513842 516073 516332 516686 516696 517816 529998 530912 532560 532680 532746 536542 537220 540511 541836 541858 545328 549836 550124 554210 555057 568379 575300 576527 576604 584195 587951 599894 599916 620663 632123 635224 639796 640530 649953 650476 667922 680484 706232 728200 728229 734469 740450 740877 741687 743029 749219 749254 752619 752644 758281 758778 786876 796314 801536 808341 811296 812017 814971 815210 815866 817025 817113 817172 817176 817556 826705 ] |
||||||||||||||||||||||||||||||
|
215.33 ms (46.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature дилд анал"
]
|
||||||||||||||||||||||||||||||
|
18.01 ms (3.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 749219 749254 752644 758778 786876 465670 513842 483523 530912 639796 439558 440911 568379 443257 468165 494481 541836 680484 493411 429900 635224 414157 650476 182118 400638 441095 428700 415758 814971 493840 536542 497905 532560 575300 599894 599916 392687 404028 494484 516332 432656 446610 537220 460378 576527 584195 632123 415988 532680 649953 516696 587951 540511 452187 424248 477081 478003 504777 532746 545328 555057 549836 728229 728200 758281 472835 513672 817556 817025 817113 817172 817176 706232 808341 743029 796314 734469 740450 812017 516686 741687 826705 801536 740877 458007 517816 423837 815210 815866 541858 667922 477757 444533 457217 500340 455603 409035 390760 443243 414122 432289 486784 464971 576604 811296 470949 458761 516073 554210 620663 443246 440944 452937 529998 510877 752619 550124 640530 437947 428174 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.52%) |
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 182118 390760 392687 400638 404028 409035 414122 414157 415758 415988 423837 424248 428174 428700 429900 432289 432656 437947 439558 440911 440944 441095 443243 443246 443257 444533 446610 452187 452937 455603 457217 458007 458761 460378 464971 465670 468165 470949 472835 477081 477757 478003 483523 486784 493411 493840 494481 494484 497905 500340 504777 510877 513672 513842 516073 516332 516686 516696 517816 529998 530912 532560 532680 532746 536542 537220 540511 541836 541858 545328 549836 550124 554210 555057 568379 575300 576527 576604 584195 587951 599894 599916 620663 632123 635224 639796 640530 649953 650476 667922 680484 706232 728200 728229 734469 740450 740877 741687 743029 749219 749254 752619 752644 758281 758778 786876 796314 801536 808341 811296 812017 814971 815210 815866 817025 817113 817172 817176 817556 826705 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature dildo anal"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"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.