Query Metrics
7
Database Queries
7
Different statements
177.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.95 ms (89.31%) |
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 130022 142773 382501 382986 396011 397739 400006 411447 411744 414956 421484 429138 443417 448359 451015 451455 451698 453674 470315 484116 493079 498980 498988 504711 512204 522372 542179 543726 549780 551221 552186 552225 553213 554181 554718 557640 560026 561153 561920 561972 562228 562299 562300 562485 567458 567531 568042 569017 570507 570567 570571 570856 571546 572428 573792 582941 583314 584723 585595 586989 587243 590292 593193 595978 600362 607301 621509 629092 631337 634263 647627 653246 653290 661701 665221 672444 672586 680390 682908 683275 688989 689212 696237 698147 698832 703279 703628 707538 708804 709396 712831 718127 718934 719453 722805 723668 725328 731762 734481 739536 768555 768933 773194 775617 777625 777940 780843 782745 791371 792800 793212 802821 802976 804902 805652 810842 813444 814134 817367 819910 ] |
||||||||||||||||||||||||||||||
|
9.73 ms (5.47%) |
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 484116 552225 554718 557640 562485 570567 570856 572428 567531 551221 560026 653246 661701 703628 707538 718934 719453 665221 682908 698147 712831 718127 653290 688989 698832 708804 561920 567458 583314 587243 607301 629092 590292 585595 600362 586989 621509 631337 634263 793212 805652 810842 777625 777940 780843 782745 802821 813444 723668 725328 739536 804902 731762 768555 768933 773194 703279 709396 775617 791371 792800 802976 382986 400006 142773 421484 470315 411744 414956 451455 397739 448359 451015 595978 734481 722805 593193 130022 396011 382501 443417 429138 411447 819910 814134 817367 453674 451698 504711 522372 498980 498988 512204 493079 562299 570571 573792 542179 549780 554181 561153 561972 562300 569017 582941 584723 543726 552186 553213 562228 568042 570507 571546 672444 672586 689212 696237 647627 680390 683275 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.28%) |
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 130022 142773 382501 382986 396011 397739 400006 411447 411744 414956 421484 429138 443417 448359 451015 451455 451698 453674 470315 484116 493079 498980 498988 504711 512204 522372 542179 543726 549780 551221 552186 552225 553213 554181 554718 557640 560026 561153 561920 561972 562228 562299 562300 562485 567458 567531 568042 569017 570507 570567 570571 570856 571546 572428 573792 582941 583314 584723 585595 586989 587243 590292 593193 595978 600362 607301 621509 629092 631337 634263 647627 653246 653290 661701 665221 672444 672586 680390 682908 683275 688989 689212 696237 698147 698832 703279 703628 707538 708804 709396 712831 718127 718934 719453 722805 723668 725328 731762 734481 739536 768555 768933 773194 775617 777625 777940 780843 782745 791371 792800 793212 802821 802976 804902 805652 810842 813444 814134 817367 819910 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny hot"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые hot"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые hot"
]
|
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.