Query Metrics
7
Database Queries
7
Different statements
145.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.64 ms (83.79%) |
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 409585 445551 467656 473586 473596 473597 483847 497117 505978 507789 514263 521359 528623 531984 532095 532116 534513 536297 538279 539739 542211 543565 547115 548040 551444 554608 559173 559533 561209 567319 576194 576609 576768 579440 579952 580580 591099 594974 599085 599090 615769 616530 616677 618184 622558 626169 636117 638743 643792 645773 646522 646668 650573 650650 651167 653754 668584 673841 676591 680853 683426 688849 695741 708146 709574 709587 710305 714327 714385 714546 716517 716840 716995 718400 730547 732800 734940 735572 739664 742527 743667 747629 748039 753127 754134 755009 757322 761101 761878 775767 775778 775782 776171 776241 778022 780101 780379 780469 787375 787854 787882 793028 793041 794402 802050 817654 819745 823975 824716 825718 826679 826772 828167 828253 828439 828454 828464 828545 828768 ] |
||||||||||||||||||||||||||||||
|
12.86 ms (8.86%) |
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 828545 793041 591099 825666 819745 775767 409585 507789 714385 646522 599085 599090 467656 521359 532095 505978 514263 559173 473597 473586 473596 445551 497117 824716 828253 828464 828439 793028 755009 732800 761101 676591 826772 828454 780379 734940 730547 778022 534513 528623 547115 576768 716840 650650 718400 594974 743667 817654 539739 551444 543565 576609 787375 739664 826679 825718 823975 828167 761878 787882 802050 828768 794402 776171 780469 787854 747629 754134 748039 757322 742527 735572 753127 780101 483847 532116 531984 536297 538279 542211 579440 561209 567319 580580 576194 579952 710305 716517 651167 653754 683426 688849 709574 709587 714546 716995 645773 646668 650573 668584 673841 680853 695741 708146 714327 548040 554608 559533 616530 616677 636117 618184 626169 643792 615769 622558 638743 776241 775778 775782 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (2.32%) |
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 409585 445551 467656 473586 473596 473597 483847 497117 505978 507789 514263 521359 528623 531984 532095 532116 534513 536297 538279 539739 542211 543565 547115 548040 551444 554608 559173 559533 561209 567319 576194 576609 576768 579440 579952 580580 591099 594974 599085 599090 615769 616530 616677 618184 622558 626169 636117 638743 643792 645773 646522 646668 650573 650650 651167 653754 668584 673841 676591 680853 683426 688849 695741 708146 709574 709587 710305 714327 714385 714546 716517 716840 716995 718400 730547 732800 734940 735572 739664 742527 743667 747629 748039 753127 754134 755009 757322 761101 761878 775767 775778 775782 776171 776241 778022 780101 780379 780469 787375 787854 787882 793028 793041 794402 802050 817654 819745 823975 824716 825718 826679 826772 828167 828253 828439 828454 828464 828545 828768 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step amateur"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
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.