Query Metrics
7
Database Queries
7
Different statements
182.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.00 ms (85.15%) |
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 383633 387652 395354 396792 399874 406010 418617 418661 420301 427044 429160 429188 429219 429226 429235 435304 451708 456627 459255 462984 465736 469102 470056 480420 487049 492495 493470 494126 497805 499415 501732 510112 511670 515800 519307 524823 526965 526980 528888 529090 535259 538478 542531 543929 551180 551384 554093 557099 557324 559938 563573 564055 564139 567608 570748 571509 573923 574267 577160 577805 577883 577884 577899 578333 579223 584126 586689 588546 589472 593927 593955 593964 593971 593988 594008 594036 594038 594114 594115 595941 597276 606223 617489 617672 622472 622675 624099 624729 625121 626381 630977 631470 634221 643396 648927 650228 659217 671410 681039 681370 684211 701292 708655 715575 747310 756861 758847 761495 777646 780561 784731 785292 787911 788294 789028 799336 800846 800854 806884 811829 ] |
||||||||||||||||||||||||||||||
|
16.89 ms (9.28%) |
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 577883 551180 564139 577805 577884 579223 671410 681039 701292 554093 557099 584126 589472 594114 606223 593955 593964 594008 617489 643396 586689 594115 597276 624099 625121 630977 634221 588546 593927 593988 594038 595941 617672 777646 785292 788294 789028 780561 787911 799336 756861 761495 784731 800846 806884 811829 747310 758847 622472 622675 631470 708655 715575 800854 387652 429188 462984 406010 429226 529090 499415 429160 451708 684211 480420 535259 418661 497805 528888 526980 494126 519307 538478 564055 570748 542531 557324 559938 567608 681370 648927 650228 659217 571509 573923 577160 624729 593971 594036 626381 427044 470056 435304 465736 501732 510112 515800 399874 456627 383633 395354 396792 418617 429219 420301 429235 469102 487049 459255 511670 526965 524823 492495 493470 551384 563573 543929 574267 577899 578333 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.56%) |
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 383633 387652 395354 396792 399874 406010 418617 418661 420301 427044 429160 429188 429219 429226 429235 435304 451708 456627 459255 462984 465736 469102 470056 480420 487049 492495 493470 494126 497805 499415 501732 510112 511670 515800 519307 524823 526965 526980 528888 529090 535259 538478 542531 543929 551180 551384 554093 557099 557324 559938 563573 564055 564139 567608 570748 571509 573923 574267 577160 577805 577883 577884 577899 578333 579223 584126 586689 588546 589472 593927 593955 593964 593971 593988 594008 594036 594038 594114 594115 595941 597276 606223 617489 617672 622472 622675 624099 624729 625121 626381 630977 631470 634221 643396 648927 650228 659217 671410 681039 681370 684211 701292 708655 715575 747310 756861 758847 761495 777646 780561 784731 785292 787911 788294 789028 799336 800846 800854 806884 811829 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"19 year old"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"19 year old"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"19 year old"
]
|
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.