Query Metrics
7
Database Queries
7
Different statements
181.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.14 ms (87.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 34697 114730 191199 192643 270601 390927 392439 398652 402037 403988 411119 412001 413742 417452 425935 429526 446351 451410 452490 456639 471428 477225 478480 488388 496469 499815 506185 511260 516206 525413 543936 550380 551551 552115 552403 553110 554791 559612 573090 578086 580260 581600 585157 585913 588158 595921 598135 599602 600241 608394 609697 617330 617588 621467 635141 635153 641445 646733 647848 665605 671408 673300 681362 699787 707856 710536 714879 715833 716112 717981 720137 720236 720351 724751 725133 727620 728021 731315 733812 740928 741213 742833 747335 748707 754260 755334 758684 760823 766368 767060 768822 770878 770899 779609 781863 782505 785468 785752 786031 789033 789540 797449 799407 807860 808236 808500 810281 810988 811362 813676 813835 814113 815450 815849 817074 817469 818474 820072 823804 827896 ] |
||||||||||||||||||||||||||||||
|
13.39 ms (7.39%) |
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 402037 635153 392439 817074 724751 578086 786031 673300 585913 758684 810281 807860 506185 813676 815849 781863 747335 768822 814113 581600 525413 621467 699787 599602 717981 665605 720137 671408 720351 585157 815450 760823 595921 789033 740928 588158 811362 731315 550380 820072 580260 716112 827896 270601 398652 742833 823804 34697 598135 728021 646733 192643 741213 647848 799407 808500 785468 748707 499815 191199 754260 553110 552403 609697 727620 797449 496469 516206 417452 559612 710536 600241 733812 543936 681362 714879 707856 617330 608394 767060 488388 412001 456639 720236 573090 818474 411119 770878 114730 390927 782505 766368 789540 617588 554791 452490 429526 641445 478480 446351 551551 785752 725133 755334 779609 810988 477225 715833 451410 770899 403988 413742 552115 471428 425935 817469 813835 808236 635141 511260 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.46%) |
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 34697 114730 191199 192643 270601 390927 392439 398652 402037 403988 411119 412001 413742 417452 425935 429526 446351 451410 452490 456639 471428 477225 478480 488388 496469 499815 506185 511260 516206 525413 543936 550380 551551 552115 552403 553110 554791 559612 573090 578086 580260 581600 585157 585913 588158 595921 598135 599602 600241 608394 609697 617330 617588 621467 635141 635153 641445 646733 647848 665605 671408 673300 681362 699787 707856 710536 714879 715833 716112 717981 720137 720236 720351 724751 725133 727620 728021 731315 733812 740928 741213 742833 747335 748707 754260 755334 758684 760823 766368 767060 768822 770878 770899 779609 781863 782505 785468 785752 786031 789033 789540 797449 799407 807860 808236 808500 810281 810988 811362 813676 813835 814113 815450 815849 817074 817469 818474 820072 823804 827896 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"super blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"super минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"super минет оральн секс"
]
|
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.