Query Metrics
7
Database Queries
7
Different statements
163.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.61 ms (88.03%) |
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 4048 6745 7169 7456 28568 40051 79520 191412 237986 314021 318795 382385 384497 384780 387977 388374 392772 395523 401802 407018 409936 410807 464803 470592 539402 539501 544684 548269 577079 581285 584177 601647 609831 630403 648210 674744 687211 689929 692049 693295 693535 694147 700661 701125 701281 702620 710928 713657 714908 716615 720637 721892 722191 723261 735443 736522 737598 737968 741898 743362 748353 750743 755396 759577 762800 765562 773342 775462 782976 784069 784213 788193 789671 789727 789751 790002 795046 795141 795299 797356 797789 798935 799010 799147 801044 801778 802514 802698 805135 808122 808209 810045 811474 811853 811989 812098 813575 813663 813819 814583 814588 815455 816991 817357 817455 817523 817724 818222 818414 821238 821521 822045 822585 825862 828194 828509 ] |
||||||||||||||||||||||||||||||
|
9.16 ms (5.62%) |
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 648210 687211 714908 737598 630403 40051 702620 817724 674744 782976 798935 750743 384497 384780 813575 548269 720637 723261 808209 710928 721892 801778 743362 795299 765562 817523 825862 759577 808122 539402 7169 388374 382385 814588 822795 828194 700661 713657 784213 812098 735443 409936 410807 79520 814583 817455 818414 539501 748353 789751 790002 797789 755396 773342 775462 789671 789727 314021 762800 6745 7456 813819 577079 584177 788193 810045 779805 387977 401802 828717 694147 470592 407018 191412 4048 741898 701125 318795 737968 821238 692049 802514 811474 701281 601647 716615 817357 828509 544684 693295 784069 811853 464803 689929 609831 797356 801044 795046 395523 818222 581285 722191 799147 802698 805135 799010 822585 816991 821521 822045 693535 795141 811989 736522 28568 237986 392772 824705 813663 815455 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.92%) |
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 4048 6745 7169 7456 28568 40051 79520 191412 237986 314021 318795 382385 384497 384780 387977 388374 392772 395523 401802 407018 409936 410807 464803 470592 539402 539501 544684 548269 577079 581285 584177 601647 609831 630403 648210 674744 687211 689929 692049 693295 693535 694147 700661 701125 701281 702620 710928 713657 714908 716615 720637 721892 722191 723261 735443 736522 737598 737968 741898 743362 748353 750743 755396 759577 762800 765562 773342 775462 782976 784069 784213 788193 789671 789727 789751 790002 795046 795141 795299 797356 797789 798935 799010 799147 801044 801778 802514 802698 805135 808122 808209 810045 811474 811853 811989 812098 813575 813663 813819 814583 814588 815455 816991 817357 817455 817523 817724 818222 818414 821238 821521 822045 822585 825862 828194 828509 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с мамашой"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс мам женщин"
]
|
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.