Query Metrics
7
Database Queries
7
Different statements
193.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.18 ms (87.51%) |
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 6739 14187 31503 34486 44909 51569 66162 123769 150124 150820 162405 188262 188462 188561 202134 234584 236863 256218 272132 330565 340635 352163 358453 382295 382444 382480 382690 383564 383594 384143 384480 384885 385664 387856 388049 389133 389713 390447 390769 391392 392054 392208 395258 395579 396418 397629 397861 398525 398562 401873 403279 405490 406593 407378 407387 407534 408240 409233 411984 413525 415780 422144 439673 440838 443326 443913 444255 448887 465789 471407 474463 479668 480656 485460 486424 488363 488619 506062 513629 519233 520021 524876 537858 538012 547809 572669 577385 589629 610033 620241 645910 651651 663972 663979 692813 693988 720341 722321 726474 727740 728305 740169 741099 744991 753663 755958 765632 765662 769580 772544 777592 788565 789292 790009 797237 800432 802147 805355 811088 824454 ] |
||||||||||||||||||||||||||||||
|
14.01 ms (7.25%) |
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 406593 480656 547809 572669 610033 340635 443913 389713 474463 382690 524876 486424 398562 692813 790009 789292 800432 802147 384480 383564 384143 202134 188262 395258 395579 382444 44909 411984 413525 422144 407378 188462 465789 162405 385664 384885 383594 272132 382480 51569 537858 645910 589629 811088 741099 772544 753663 740169 409233 403279 256218 728305 358453 389133 397629 788565 765632 392208 6739 150820 31503 14187 388049 390769 396418 398525 824454 506062 651651 693988 663972 663979 620241 805355 744991 765662 727740 401873 123769 188561 439673 397861 387856 444255 382295 408240 471407 392054 443326 519233 513629 520021 485460 538012 150124 352163 34486 407387 720341 777592 797237 726474 755958 769580 722321 407534 330565 236863 234584 66162 390447 391392 405490 415780 440838 448887 488619 479668 488363 577385 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.26%) |
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 6739 14187 31503 34486 44909 51569 66162 123769 150124 150820 162405 188262 188462 188561 202134 234584 236863 256218 272132 330565 340635 352163 358453 382295 382444 382480 382690 383564 383594 384143 384480 384885 385664 387856 388049 389133 389713 390447 390769 391392 392054 392208 395258 395579 396418 397629 397861 398525 398562 401873 403279 405490 406593 407378 407387 407534 408240 409233 411984 413525 415780 422144 439673 440838 443326 443913 444255 448887 465789 471407 474463 479668 480656 485460 486424 488363 488619 506062 513629 519233 520021 524876 537858 538012 547809 572669 577385 589629 610033 620241 645910 651651 663972 663979 692813 693988 720341 722321 726474 727740 728305 740169 741099 744991 753663 755958 765632 765662 769580 772544 777592 788565 789292 790009 797237 800432 802147 805355 811088 824454 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"тёщ и"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.