Query Metrics
7
Database Queries
7
Different statements
203.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.38 ms (87.94%) |
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 233335 385288 385816 389979 396408 397843 402261 416163 418132 419155 420322 421346 426666 426984 428027 429125 432395 432396 432412 432464 433433 433676 435620 452538 453011 457749 460354 460356 460507 461955 465830 465835 465882 465921 466045 469157 478693 480091 486329 503877 505992 534475 536084 536100 552112 560334 561917 565831 572917 578328 580027 591420 616989 617778 618808 627154 627181 636719 638840 662833 677847 698619 698782 703944 714395 721738 725889 728996 731456 734703 736886 739156 740578 742330 744346 745006 745081 746575 749538 750224 750401 750552 752336 756277 756480 756702 757514 758906 760624 760688 760934 761575 766051 767548 767989 768697 768888 769366 770236 771049 771353 772168 772243 772635 776032 777264 777731 777767 779070 781051 782106 788485 790500 791036 793099 796476 796994 802944 806764 811103 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (7.32%) |
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 767548 770236 771049 771353 745081 749538 750224 750552 758906 760934 728996 740578 742330 746575 752336 756702 766051 768888 769366 725889 734703 736886 745006 750401 756277 760624 760688 761575 772168 772243 772635 617778 627181 698619 698782 777264 777731 777767 779070 781051 782106 790500 796994 802944 806764 466045 402261 233335 385816 429125 461955 433433 421346 416163 428027 435620 418132 480091 457749 505992 536084 503877 536100 534475 486329 552112 565831 580027 572917 560334 561917 578328 677847 703944 714395 662833 721738 616989 636719 618808 591420 638840 788485 776032 793099 796476 731456 744346 757514 739156 756480 767989 768697 627154 791036 811103 426666 432395 432464 453011 460356 465830 478693 385288 389979 420322 433676 460507 465835 465882 465921 469157 396408 397843 432412 460354 419155 426984 432396 452538 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.27%) |
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 233335 385288 385816 389979 396408 397843 402261 416163 418132 419155 420322 421346 426666 426984 428027 429125 432395 432396 432412 432464 433433 433676 435620 452538 453011 457749 460354 460356 460507 461955 465830 465835 465882 465921 466045 469157 478693 480091 486329 503877 505992 534475 536084 536100 552112 560334 561917 565831 572917 578328 580027 591420 616989 617778 618808 627154 627181 636719 638840 662833 677847 698619 698782 703944 714395 721738 725889 728996 731456 734703 736886 739156 740578 742330 744346 745006 745081 746575 749538 750224 750401 750552 752336 756277 756480 756702 757514 758906 760624 760688 760934 761575 766051 767548 767989 768697 768888 769366 770236 771049 771353 772168 772243 772635 776032 777264 777731 777767 779070 781051 782106 788485 790500 791036 793099 796476 796994 802944 806764 811103 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в колготках молодые и%…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"колготк молодые"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.75%) |
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.