Query Metrics
7
Database Queries
7
Different statements
181.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.91 ms (88.02%) |
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 426666 470851 493427 514274 514380 514568 516845 524404 531887 541870 550324 551589 552998 558219 558804 559094 559100 562920 576428 578093 581089 583694 590740 599513 601349 601675 605281 605844 606565 618415 618540 618853 619774 621524 624857 626165 626734 633722 645194 649087 650213 652766 657562 657631 657966 662066 662080 666476 667230 670782 671523 671591 675784 677028 686860 687318 692383 693403 693567 706411 709947 714140 716583 717620 719040 719602 721118 721137 721206 721310 721341 721364 725891 729065 730674 731933 733847 733852 741950 745385 747938 754487 754541 754574 755389 760453 760925 763236 769907 771141 774447 777506 777667 786050 787179 787219 788167 788175 788247 788750 789949 790038 796986 797854 797916 798014 799784 800010 801036 802596 806064 806878 808379 811075 811311 811629 812907 814083 814282 815123 ] |
||||||||||||||||||||||||||||||
|
12.24 ms (6.74%) |
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 755389 769907 760925 721137 788175 789949 657631 605844 618853 774447 814083 815123 559100 551589 562920 692383 719040 721364 657562 621524 797916 799784 806064 811629 777506 777667 788167 729065 745385 760453 808379 811075 725891 730674 754487 754541 606565 786050 787179 811311 493427 670782 650213 814282 531887 541870 578093 649087 675784 716583 719602 686860 666476 601349 619774 624857 599513 626734 800010 801036 763236 733852 754574 721341 790038 812907 426666 470851 514274 514380 524404 671591 645194 693403 657966 677028 721310 605281 618415 618540 788247 788750 787219 796986 798014 802596 806878 731933 733847 747938 771141 741950 633722 797854 516845 514568 581089 550324 590740 626165 601675 558804 558219 583694 559094 576428 552998 652766 662066 671523 717620 721118 662080 667230 706411 714140 721206 687318 693567 709947 ] |
||||||||||||||||||||||||||||||
|
2.72 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 426666 470851 493427 514274 514380 514568 516845 524404 531887 541870 550324 551589 552998 558219 558804 559094 559100 562920 576428 578093 581089 583694 590740 599513 601349 601675 605281 605844 606565 618415 618540 618853 619774 621524 624857 626165 626734 633722 645194 649087 650213 652766 657562 657631 657966 662066 662080 666476 667230 670782 671523 671591 675784 677028 686860 687318 692383 693403 693567 706411 709947 714140 716583 717620 719040 719602 721118 721137 721206 721310 721341 721364 725891 729065 730674 731933 733847 733852 741950 745385 747938 754487 754541 754574 755389 760453 760925 763236 769907 771141 774447 777506 777667 786050 787179 787219 788167 788175 788247 788750 789949 790038 796986 797854 797916 798014 799784 800010 801036 802596 806064 806878 808379 811075 811311 811629 812907 814083 814282 815123 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"татуированные крошки"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"татуированные крошк"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.