Query Metrics
7
Database Queries
7
Different statements
180.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.07 ms (83.01%) |
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 395889 400470 400857 401909 406969 407658 414317 421969 422147 422171 424276 427317 432876 439713 439747 439798 443669 445850 446522 446967 447793 448722 449623 453293 457572 457850 460704 464015 464337 470980 471645 473309 474783 475839 478376 480246 482306 482333 482396 484611 487340 496346 496347 514304 514804 516236 528394 540370 546116 546912 553972 561489 563154 565794 569972 573739 578037 591587 612067 623075 623649 634849 638550 666420 668459 669391 670747 670853 673658 680860 687561 689373 701253 704925 710571 712338 714623 715050 716566 717631 720603 738203 738834 745394 758436 758584 761230 764151 770478 776518 777734 780612 784085 785426 786428 788288 788588 788868 788875 788885 789276 795033 795276 795750 798616 799131 806356 807352 807401 807416 807517 807546 808017 808537 808558 809354 813916 813917 820330 823804 ] |
||||||||||||||||||||||||||||||
|
21.79 ms (12.05%) |
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 764151 789276 795033 808558 738203 738834 758584 710571 715050 720603 780612 786428 806356 447793 453293 401909 406969 484611 400470 407658 421969 432876 813916 823804 448722 464015 482396 471645 473309 514304 528394 540370 496347 482333 546912 666420 669391 670747 673658 689373 704925 712338 714623 717631 668459 670853 680860 561489 563154 565794 623075 623649 634849 591587 612067 638550 788875 807352 807401 776518 807416 809354 758436 770478 784085 788868 807546 808017 808537 745394 761230 701253 716566 777734 785426 788288 788588 788885 795276 795750 798616 799131 807517 460704 478376 422147 424276 439747 445850 427317 443669 449623 475839 480246 446522 496346 516236 400857 439798 439713 422171 395889 414317 813917 820330 474783 482306 457572 457850 470980 446967 464337 514804 487340 553972 578037 546116 569972 573739 687561 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.50%) |
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 395889 400470 400857 401909 406969 407658 414317 421969 422147 422171 424276 427317 432876 439713 439747 439798 443669 445850 446522 446967 447793 448722 449623 453293 457572 457850 460704 464015 464337 470980 471645 473309 474783 475839 478376 480246 482306 482333 482396 484611 487340 496346 496347 514304 514804 516236 528394 540370 546116 546912 553972 561489 563154 565794 569972 573739 578037 591587 612067 623075 623649 634849 638550 666420 668459 669391 670747 670853 673658 680860 687561 689373 701253 704925 710571 712338 714623 715050 716566 717631 720603 738203 738834 745394 758436 758584 761230 764151 770478 776518 777734 780612 784085 785426 786428 788288 788588 788868 788875 788885 789276 795033 795276 795750 798616 799131 806356 807352 807401 807416 807517 807546 808017 808537 808558 809354 813916 813917 820330 823804 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom stepson"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom stepson"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom stepson"
]
|
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.