Query Metrics
7
Database Queries
7
Different statements
139.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.34 ms (82.73%) |
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 393865 400134 400143 400166 401799 402999 403600 407154 408293 409144 413889 425998 428454 428822 430833 430835 430839 430979 432524 432601 432834 437583 438031 438324 455281 456736 464661 470871 472913 478107 481346 481874 486008 486023 486539 500578 510287 512063 515802 518062 518735 524109 529202 531923 532130 533959 533965 535010 539830 540549 546754 548848 551069 551070 559678 561568 565050 565631 579761 580300 587685 587693 596011 599703 601234 604157 617677 664660 668948 674743 684308 688313 690091 693256 696171 698312 699536 702904 706266 709408 710310 710575 710604 714457 714475 715662 724295 727622 730524 739965 756920 760616 763280 769163 770006 772322 775129 785180 786455 788161 788610 788961 789750 790017 790596 791182 793171 797632 799230 799936 803217 803762 804620 805700 806741 807452 807454 813268 820148 823263 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (10.38%) |
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 409144 486008 804620 402999 428454 668948 696171 709408 706266 587693 596011 617677 775129 788961 790596 799230 730524 500578 599703 403600 432834 455281 456736 601234 408293 400143 393865 478107 481874 437583 407154 430835 510287 533959 535010 486023 539830 551070 813268 472913 428822 512063 559678 565631 481346 524109 565050 579761 561568 715662 664660 587685 788610 786455 702904 693256 674743 803762 785180 791182 756920 788161 789750 793171 805700 772322 790017 425998 515802 551069 698312 799936 432601 432524 531923 532130 546754 684308 688313 604157 727622 797632 438324 400134 438031 470871 518735 518062 400166 464661 540549 548848 714475 580300 699536 714457 401799 413889 430979 430833 430839 529202 533965 486539 820148 823263 710575 690091 710310 710604 807452 769163 770006 724295 739965 760616 763280 803217 806741 807454 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.75%) |
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 393865 400134 400143 400166 401799 402999 403600 407154 408293 409144 413889 425998 428454 428822 430833 430835 430839 430979 432524 432601 432834 437583 438031 438324 455281 456736 464661 470871 472913 478107 481346 481874 486008 486023 486539 500578 510287 512063 515802 518062 518735 524109 529202 531923 532130 533959 533965 535010 539830 540549 546754 548848 551069 551070 559678 561568 565050 565631 579761 580300 587685 587693 596011 599703 601234 604157 617677 664660 668948 674743 684308 688313 690091 693256 696171 698312 699536 702904 706266 709408 710310 710575 710604 714457 714475 715662 724295 727622 730524 739965 756920 760616 763280 769163 770006 772322 775129 785180 786455 788161 788610 788961 789750 790017 790596 791182 793171 797632 799230 799936 803217 803762 804620 805700 806741 807452 807454 813268 820148 823263 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty step mom"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty step mom"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty step mom"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.