Query Metrics
7
Database Queries
7
Different statements
189.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.63 ms (85.62%) |
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 386197 390538 392881 394535 395175 395410 405020 421466 427580 434839 437333 446359 446578 447007 451038 454137 455487 457765 459965 460844 463567 465894 470128 471497 472790 476521 484830 484849 484858 486152 486392 488729 488733 495600 496850 497563 497582 498776 504197 508297 511259 511708 511755 512278 512821 516817 520561 520751 521158 521904 523292 523293 523313 523316 523677 529547 532916 533003 533325 535575 539075 539106 539820 543260 549806 549808 552792 553990 561081 562265 566865 574781 575501 575787 576359 579223 579947 585111 586532 588262 589139 592692 604363 605296 606569 610938 614262 615367 617620 621999 629770 644224 646228 647815 654691 661264 677821 689804 692506 701673 706836 709747 712765 720211 728123 748243 781511 785292 786839 789155 794844 798499 801742 809070 812734 815543 821316 822642 823501 827943 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (9.23%) |
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 720211 549806 562265 566865 586532 471497 446359 421466 446578 472790 529547 484830 488729 484858 486152 497563 386197 392881 434839 585111 821316 822642 823501 460844 457765 470128 521158 539820 508297 520751 535575 561081 579223 646228 654691 677821 689804 712765 647815 692506 706836 604363 610938 615367 621999 588262 629770 617620 644224 785292 812734 798499 809070 794844 801742 748243 728123 606569 701673 709747 786839 789155 395175 465894 498776 427580 815543 459965 511259 532916 549808 575501 543260 552792 575787 661264 553990 574781 576359 579947 589139 614262 592692 605296 781511 395410 390538 394535 405020 454137 476521 504197 523293 486392 488733 495600 512278 516817 523292 523677 484849 497582 511708 512821 521904 523316 496850 511755 523313 437333 827943 447007 451038 455487 463567 539075 539106 520561 533003 533325 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.62%) |
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 386197 390538 392881 394535 395175 395410 405020 421466 427580 434839 437333 446359 446578 447007 451038 454137 455487 457765 459965 460844 463567 465894 470128 471497 472790 476521 484830 484849 484858 486152 486392 488729 488733 495600 496850 497563 497582 498776 504197 508297 511259 511708 511755 512278 512821 516817 520561 520751 521158 521904 523292 523293 523313 523316 523677 529547 532916 533003 533325 535575 539075 539106 539820 543260 549806 549808 552792 553990 561081 562265 566865 574781 575501 575787 576359 579223 579947 585111 586532 588262 589139 592692 604363 605296 606569 610938 614262 615367 617620 621999 629770 644224 646228 647815 654691 661264 677821 689804 692506 701673 706836 709747 712765 720211 728123 748243 781511 785292 786839 789155 794844 798499 801742 809070 812734 815543 821316 822642 823501 827943 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl party"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк party"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк party"
]
|
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.