Query Metrics
7
Database Queries
7
Different statements
183.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.90 ms (85.29%) |
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 8900 24363 56632 384585 385234 387347 390838 394582 395285 397190 405761 412078 418575 419616 427057 427148 427771 436965 441762 446690 452454 455324 456654 459887 465990 472373 472772 481265 490238 506306 506833 509430 514034 517773 528294 530937 532301 538991 539976 546617 549705 549721 550797 560576 561784 574442 580817 582887 588325 592080 603054 605698 635720 649059 649269 657867 664717 666494 668733 669515 672811 673668 701194 702350 708226 723764 725092 725485 728255 729292 731389 736388 736392 738382 738675 741744 744094 744404 745335 751170 751226 751360 753206 754653 757708 758377 758379 758386 761022 764104 768287 769197 769324 771145 771933 775720 784320 787830 788031 788156 790399 791638 793011 793602 794446 795884 797364 802244 803915 804140 805145 811816 811862 811882 811889 811900 813168 816841 823822 828520 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (9.18%) |
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 635720 784320 797364 811900 813168 736388 723764 738675 741744 738382 751360 754653 768287 725485 757708 791638 794446 56632 456654 390838 816841 828520 788031 771145 605698 24363 397190 436965 528294 758379 731389 387347 472373 546617 702350 668733 793602 745335 769197 764104 538991 580817 758377 761022 418575 506833 509430 823822 384585 385234 395285 8900 405761 427771 427148 427057 441762 455324 514034 532301 506306 530937 481265 549705 560576 582887 649269 672811 649059 657867 669515 664717 666494 673668 708226 549721 574442 588325 592080 603054 787830 790399 795884 804140 805145 775720 811882 725092 744094 758386 769324 788156 736392 744404 751170 753206 729292 751226 771933 701194 793011 802244 803915 811816 811862 811889 412078 472772 446690 459887 419616 490238 394582 561784 550797 517773 728255 452454 465990 539976 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.54%) |
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 8900 24363 56632 384585 385234 387347 390838 394582 395285 397190 405761 412078 418575 419616 427057 427148 427771 436965 441762 446690 452454 455324 456654 459887 465990 472373 472772 481265 490238 506306 506833 509430 514034 517773 528294 530937 532301 538991 539976 546617 549705 549721 550797 560576 561784 574442 580817 582887 588325 592080 603054 605698 635720 649059 649269 657867 664717 666494 668733 669515 672811 673668 701194 702350 708226 723764 725092 725485 728255 729292 731389 736388 736392 738382 738675 741744 744094 744404 745335 751170 751226 751360 753206 754653 757708 758377 758379 758386 761022 764104 768287 769197 769324 771145 771933 775720 784320 787830 788031 788156 790399 791638 793011 793602 794446 795884 797364 802244 803915 804140 805145 811816 811862 811882 811889 811900 813168 816841 823822 828520 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom wife"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван жен"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
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.