Query Metrics
7
Database Queries
7
Different statements
201.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.32 ms (88.33%) |
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 246527 359075 382518 383209 384124 389355 389442 390231 391576 392674 392952 394206 395147 397888 397905 398209 400809 400989 400999 406976 407780 408411 409234 409936 419534 419839 421108 425530 439472 439572 439675 443719 444168 448708 452081 458691 460753 463837 465592 466195 466206 466229 466231 466254 468114 469386 469403 470936 470967 472821 479051 479145 480738 484564 485462 485869 486534 489495 490410 491637 491910 491989 491994 496547 497492 499199 504057 516633 522622 523662 524886 524987 526708 541398 544484 544501 544865 554906 563137 563180 563184 563189 563203 563212 564175 569943 598937 599246 603656 605694 620663 628354 663440 678767 678790 715525 716858 718581 720536 720583 726786 726862 728146 730104 748222 748232 759980 774187 788517 789539 807997 808139 811837 811984 814794 818642 818802 819009 820327 824604 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (7.45%) |
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 811837 788517 564175 524886 392952 544501 663440 563137 400999 383209 390231 392674 394206 466254 491994 496547 389355 544484 554906 389442 419839 419534 544865 499199 465592 485462 491910 485869 406976 563203 400809 504057 598937 425530 443719 468114 818802 818642 720536 808139 397888 452081 524987 563184 439675 490410 470936 421108 469386 678767 466206 497492 523662 466195 439472 491637 563180 748222 728146 718581 409234 480738 409936 824604 789539 726786 246527 819009 726862 359075 458691 811984 516633 526708 486534 603656 605694 563189 748232 391576 439572 444168 807997 489495 541398 398209 407780 469403 569943 400989 448708 460753 479051 397905 479145 384124 484564 491989 620663 472821 470967 395147 466231 466229 522622 720583 774187 463837 678790 382518 408411 820327 814794 563212 715525 716858 599246 628354 730104 759980 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.08%) |
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 246527 359075 382518 383209 384124 389355 389442 390231 391576 392674 392952 394206 395147 397888 397905 398209 400809 400989 400999 406976 407780 408411 409234 409936 419534 419839 421108 425530 439472 439572 439675 443719 444168 448708 452081 458691 460753 463837 465592 466195 466206 466229 466231 466254 468114 469386 469403 470936 470967 472821 479051 479145 480738 484564 485462 485869 486534 489495 490410 491637 491910 491989 491994 496547 497492 499199 504057 516633 522622 523662 524886 524987 526708 541398 544484 544501 544865 554906 563137 563180 563184 563189 563203 563212 564175 569943 598937 599246 603656 605694 620663 628354 663440 678767 678790 715525 716858 718581 720536 720583 726786 726862 728146 730104 748222 748232 759980 774187 788517 789539 807997 808139 811837 811984 814794 818642 818802 819009 820327 824604 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick stockings mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза чулк нижн бел mature"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза чулк нижн бел mature"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.68%) |
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.