Query Metrics
7
Database Queries
7
Different statements
273.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
248.13 ms (90.86%) |
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 45605 90684 153425 181804 187186 381838 387230 389631 391583 391669 392605 395646 397479 402664 407786 411715 411902 415543 415557 415579 418407 418803 428079 428141 428881 436608 443174 443669 443703 443997 448557 453270 453276 455114 458103 469341 470737 471053 471390 474499 474780 479177 482896 488324 489439 492815 500437 514905 516146 526743 526892 529039 546934 546951 548571 551293 555750 555793 560183 561350 563222 564180 564197 569861 570638 571210 571713 574839 582784 584890 586671 587902 597494 597811 602665 605324 607192 617405 619987 628811 631970 657865 664322 665273 665384 666778 667899 675866 680794 705669 716577 719141 720609 725565 731371 731768 732086 732482 742595 743381 747976 760068 765298 768188 770494 774000 785426 786254 786277 789310 790874 790983 796129 797909 810981 811425 814885 814930 823261 826764 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (5.64%) |
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 187186 387230 397479 407786 428079 411715 411902 428141 453276 453270 546934 564180 555750 665273 680794 664322 665384 666778 555793 563222 564197 602665 607192 619987 631970 790983 731768 770494 786254 742595 720609 785426 786277 45605 153425 443703 479177 443669 443997 482896 560183 574839 747976 436608 492815 529039 548571 570638 716577 587902 768188 418803 418407 455114 470737 500437 551293 675866 719141 657865 605324 597811 811425 395646 628811 826764 448557 488324 546951 705669 561350 597494 617405 760068 731371 732086 743381 774000 732482 90684 389631 381838 402664 443174 489439 514905 516146 569861 571210 458103 415543 415579 415557 428881 814930 814885 823261 471390 469341 526743 526892 474499 571713 582784 584890 667899 586671 789310 790874 797909 725565 765298 796129 810981 392605 471053 181804 391583 474780 391669 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.05%) |
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 45605 90684 153425 181804 187186 381838 387230 389631 391583 391669 392605 395646 397479 402664 407786 411715 411902 415543 415557 415579 418407 418803 428079 428141 428881 436608 443174 443669 443703 443997 448557 453270 453276 455114 458103 469341 470737 471053 471390 474499 474780 479177 482896 488324 489439 492815 500437 514905 516146 526743 526892 529039 546934 546951 548571 551293 555750 555793 560183 561350 563222 564180 564197 569861 570638 571210 571713 574839 582784 584890 586671 587902 597494 597811 602665 605324 607192 617405 619987 628811 631970 657865 664322 665273 665384 666778 667899 675866 680794 705669 716577 719141 720609 725565 731371 731768 732086 732482 742595 743381 747976 760068 765298 768188 770494 774000 785426 786254 786277 789310 790874 790983 796129 797909 810981 811425 814885 814930 823261 826764 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old sexy 18"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old sexy 18"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old sexy 18"
]
|
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.