Query Metrics
7
Database Queries
7
Different statements
220.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
180.87 ms (82.19%) |
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 32485 61498 109041 223442 360205 364718 382383 386316 388436 389683 389711 395894 398577 400747 401940 413898 417240 417708 417709 417716 417731 420426 422398 424535 426389 428423 429264 442626 445993 451606 453085 455837 455850 456607 458584 458686 458830 460100 460395 461301 461861 461903 466671 470224 473647 475532 475574 475867 478212 478261 479970 480694 482882 483239 487159 488877 489208 491388 494046 494235 497172 499706 500277 503691 503995 504613 504833 505947 506868 509544 517946 521942 522833 525650 527074 544299 546380 546446 549101 549222 551188 551227 555440 557895 562804 564456 565398 567453 569849 569865 570009 570028 570356 570436 570609 571586 571598 575760 578133 579511 599792 601580 606265 617647 621648 626911 649912 666772 705640 719915 722644 729357 787418 817549 818657 820542 821065 821232 822815 825580 ] |
||||||||||||||||||||||||||||||
|
23.29 ms (10.58%) |
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 456607 722644 579511 382383 606265 473647 389711 719915 599792 417240 505947 223442 488877 562804 109041 417709 483239 525650 649912 442626 487159 466671 549222 569865 626911 458686 557895 787418 401940 428423 461861 621648 480694 398577 817549 818657 570609 417731 570009 460100 522833 422398 461903 453085 564456 389683 546446 729357 601580 475532 546380 569849 504613 821065 822815 500277 400747 424535 461301 494235 499706 509544 426389 570028 570436 570356 458584 820542 571598 705640 567453 527074 364718 32485 544299 482882 455837 360205 503995 504833 460395 475574 395894 825580 575760 429264 386316 549101 61498 555440 445993 506868 417716 413898 521942 821232 617647 388436 417708 478261 497172 571586 565398 666772 455850 503691 489208 420426 451606 458830 470224 475867 551227 551188 578133 478212 479970 491388 494046 517946 ] |
||||||||||||||||||||||||||||||
|
8.49 ms (3.86%) |
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 32485 61498 109041 223442 360205 364718 382383 386316 388436 389683 389711 395894 398577 400747 401940 413898 417240 417708 417709 417716 417731 420426 422398 424535 426389 428423 429264 442626 445993 451606 453085 455837 455850 456607 458584 458686 458830 460100 460395 461301 461861 461903 466671 470224 473647 475532 475574 475867 478212 478261 479970 480694 482882 483239 487159 488877 489208 491388 494046 494235 497172 499706 500277 503691 503995 504613 504833 505947 506868 509544 517946 521942 522833 525650 527074 544299 546380 546446 549101 549222 551188 551227 555440 557895 562804 564456 565398 567453 569849 569865 570009 570028 570356 570436 570609 571586 571598 575760 578133 579511 599792 601580 606265 617647 621648 626911 649912 666772 705640 719915 722644 729357 787418 817549 818657 820542 821065 821232 822815 825580 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex park"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс парк природ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
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.