Query Metrics
7
Database Queries
7
Different statements
187.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.78 ms (86.30%) |
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 385315 393432 393972 404434 434458 438212 449218 476909 484063 522695 523921 524175 531176 532119 532220 533410 534515 534845 557228 557262 557498 559207 561579 561585 563926 564290 572636 574330 584106 584160 593972 616524 624390 625496 637586 652109 659476 660601 661514 673818 678229 685355 687522 698312 700539 701790 702674 703099 707425 708913 713042 715735 718191 720179 725718 729867 732215 744173 744183 744217 748117 748544 754226 757148 759383 760436 760714 761771 764623 764736 765530 767092 768244 771916 777336 777542 781088 781583 782786 785792 789167 789912 791120 793228 795212 804978 810167 812622 814204 816135 816773 817590 817738 818434 819109 819889 820205 820323 821768 821774 823178 823781 823918 824487 824767 824832 825095 825620 825639 825759 825820 826437 826920 827413 827546 827866 827889 827905 827911 827914 ] |
||||||||||||||||||||||||||||||
|
15.03 ms (8.02%) |
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 748544 703099 707425 393432 393972 434458 687522 476909 534845 698312 624390 820205 659476 661514 764736 438212 827889 522695 531176 559207 685355 702674 760436 768244 385315 816773 824767 825620 826920 827546 817590 824832 825759 820323 824487 827914 827866 524175 533410 557262 584106 584160 557228 678229 715735 652109 660601 708913 673818 700539 713042 718191 593972 616524 625496 777542 781088 782786 785792 781583 789912 812622 744173 744183 757148 789167 791120 754226 767092 729867 760714 764623 765530 725718 732215 744217 748117 759383 761771 771916 637586 701790 720179 777336 793228 795212 804978 810167 449218 404434 818434 819109 823178 823781 825095 825820 826437 821768 825639 827413 816135 817738 821774 814204 819889 827905 827911 823918 532220 534515 523921 532119 484063 557498 561585 561579 563926 564290 572636 574330 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.58%) |
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 385315 393432 393972 404434 434458 438212 449218 476909 484063 522695 523921 524175 531176 532119 532220 533410 534515 534845 557228 557262 557498 559207 561579 561585 563926 564290 572636 574330 584106 584160 593972 616524 624390 625496 637586 652109 659476 660601 661514 673818 678229 685355 687522 698312 700539 701790 702674 703099 707425 708913 713042 715735 718191 720179 725718 729867 732215 744173 744183 744217 748117 748544 754226 757148 759383 760436 760714 761771 764623 764736 765530 767092 768244 771916 777336 777542 781088 781583 782786 785792 789167 789912 791120 793228 795212 804978 810167 812622 814204 816135 816773 817590 817738 818434 819109 819889 820205 820323 821768 821774 823178 823781 823918 824487 824767 824832 825095 825620 825639 825759 825820 826437 826920 827413 827546 827866 827889 827905 827911 827914 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step girls"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step девушк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step девушк"
]
|
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.