Query Metrics
7
Database Queries
7
Different statements
181.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.33 ms (85.55%) |
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 21576 404364 410311 415530 420236 421594 423209 436859 437518 443024 444690 445028 445044 445263 445444 445616 448697 450707 455657 461512 461862 468589 475228 478208 478250 480334 484841 487086 488214 488872 490759 491679 492677 493063 495648 499565 500173 501535 501883 502018 504937 505045 508825 511928 513752 515468 516161 522169 522810 522818 528092 528609 528891 529259 530018 530709 532248 534025 537934 539075 543084 548710 548734 550759 551218 551278 551520 556361 558654 559315 560541 560684 560917 561649 564449 564655 565021 565263 565287 566514 566579 568222 568460 569685 570266 572126 572370 572387 572519 573360 574490 575355 577117 580291 580678 580746 580791 581089 581630 581669 584565 584812 586500 586959 589942 592329 592459 593921 597263 607742 622230 639975 641757 660943 670965 673547 674330 684173 689750 712822 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (8.31%) |
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 478250 480334 21576 420236 445028 475228 445044 445263 445616 461512 478208 501535 511928 522810 529259 487086 499565 501883 505045 516161 484841 488872 490759 513752 488214 492677 515468 522818 528092 528609 530018 530709 597263 404364 410311 423209 415530 437518 444690 421594 443024 436859 450707 468589 445444 448697 461862 493063 455657 491679 539075 500173 504937 508825 534025 495648 502018 522169 537934 528891 532248 543084 558654 559315 565021 565287 568222 570266 572370 580291 580791 581089 581630 584565 551218 551520 556361 560684 564655 566514 568460 569685 572387 573360 575355 577117 580746 581669 584812 548710 560541 561649 564449 565263 566579 572519 673547 674330 670965 689750 712822 660943 684173 548734 550759 551278 560917 572126 574490 580678 586959 592459 593921 622230 641757 592329 607742 639975 586500 589942 ] |
||||||||||||||||||||||||||||||
|
4.12 ms (2.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 21576 404364 410311 415530 420236 421594 423209 436859 437518 443024 444690 445028 445044 445263 445444 445616 448697 450707 455657 461512 461862 468589 475228 478208 478250 480334 484841 487086 488214 488872 490759 491679 492677 493063 495648 499565 500173 501535 501883 502018 504937 505045 508825 511928 513752 515468 516161 522169 522810 522818 528092 528609 528891 529259 530018 530709 532248 534025 537934 539075 543084 548710 548734 550759 551218 551278 551520 556361 558654 559315 560541 560684 560917 561649 564449 564655 565021 565263 565287 566514 566579 568222 568460 569685 570266 572126 572370 572387 572519 573360 574490 575355 577117 580291 580678 580746 580791 581089 581630 581669 584565 584812 586500 586959 589942 592329 592459 593921 597263 607742 622230 639975 641757 660943 670965 673547 674330 684173 689750 712822 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые babe"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny babe"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые babe"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.