Query Metrics
7
Database Queries
7
Different statements
190.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.61 ms (85.25%) |
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 7981 123147 345630 383250 384757 386865 387363 388764 389448 390530 391049 395752 395818 396341 396990 400056 400137 401933 402125 402251 403900 404462 409895 410642 411736 412132 414120 415506 416863 418837 419321 419773 424325 426576 426719 427243 430349 430357 430836 431022 432296 433241 433486 433675 434163 443790 450318 453635 454273 455265 456525 456869 461840 461961 465411 465490 466644 467876 469079 470002 470935 472829 474004 474495 477347 478832 482720 489443 490265 490729 491119 491771 492625 494771 496038 506580 508277 509033 512069 518927 522212 523479 523491 524170 526487 530752 531072 543731 546082 560437 562000 576689 584731 589146 591126 593799 595744 597207 603241 603295 603642 631673 654275 666589 667230 668144 691832 699610 725314 736489 753248 766022 770217 773742 782777 802691 809913 811062 811072 814396 ] |
||||||||||||||||||||||||||||||
|
17.63 ms (9.24%) |
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 546082 560437 654275 691832 631673 595744 811062 782777 802691 766022 753248 773742 811072 395752 477347 345630 402125 383250 512069 489443 490729 523479 506580 523491 410642 478832 465490 461840 430349 453635 403900 470935 7981 400137 404462 409895 494771 490265 384757 388764 433486 432296 412132 419773 491771 455265 666589 430357 508277 395818 387363 518927 418837 433241 461961 576689 699610 603295 597207 603241 401933 424325 431022 443790 522212 531072 562000 386865 123147 391049 396990 400056 402251 419321 482720 465411 526487 496038 530752 469079 584731 668144 667230 589146 725314 736489 770217 809913 396341 456869 433675 466644 416863 467876 414120 454273 524170 411736 426719 415506 591126 474495 470002 593799 450318 543731 603642 389448 430836 472829 491119 492625 509033 390530 426576 434163 427243 814396 474004 456525 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.79%) |
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 7981 123147 345630 383250 384757 386865 387363 388764 389448 390530 391049 395752 395818 396341 396990 400056 400137 401933 402125 402251 403900 404462 409895 410642 411736 412132 414120 415506 416863 418837 419321 419773 424325 426576 426719 427243 430349 430357 430836 431022 432296 433241 433486 433675 434163 443790 450318 453635 454273 455265 456525 456869 461840 461961 465411 465490 466644 467876 469079 470002 470935 472829 474004 474495 477347 478832 482720 489443 490265 490729 491119 491771 492625 494771 496038 506580 508277 509033 512069 518927 522212 523479 523491 524170 526487 530752 531072 543731 546082 560437 562000 576689 584731 589146 591126 593799 595744 597207 603241 603295 603642 631673 654275 666589 667230 668144 691832 699610 725314 736489 753248 766022 770217 773742 782777 802691 809913 811062 811072 814396 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"две мамаши"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"две мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
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.