Query Metrics
7
Database Queries
7
Different statements
147.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.65 ms (82.23%) |
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 53992 90718 118282 145424 163429 399520 403421 411729 411742 418646 422862 424023 431452 435735 445057 445363 447105 447462 449019 461568 464283 468593 469898 471505 472251 473037 473322 476749 477980 479689 485673 491193 492414 498025 498064 508109 508894 513070 515215 516402 521225 528146 530959 531595 531760 534732 540864 545167 547373 548533 548654 551947 556379 559892 562513 562804 566047 566170 569155 571657 573062 573622 573684 573714 574247 577794 578472 581659 581687 581964 583594 584126 584666 587527 590436 595363 595451 596785 598871 607437 617968 624831 629954 631044 638623 649267 660761 665381 676927 676944 678218 684304 716468 722157 724903 727921 730579 735773 735785 737825 744037 744083 744095 748121 749533 753153 764758 764810 775313 787955 792198 793518 796362 797234 800619 809429 809724 813905 817364 818994 ] |
||||||||||||||||||||||||||||||
|
15.90 ms (10.75%) |
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 559892 479689 447462 530959 722157 547373 792198 737825 676927 163429 548533 508894 531595 649267 660761 678218 793518 735773 744037 744083 118282 607437 473037 545167 631044 468593 411742 540864 485673 583594 753153 764758 724903 403421 727921 676944 573684 566047 584126 498025 629954 515215 581659 574247 590436 573062 581964 477980 431452 447105 775313 748121 796362 797234 735785 764810 749533 809724 562513 491193 813905 473322 521225 551947 584666 556379 624831 638623 595451 595363 809429 744095 53992 418646 476749 469898 800619 435735 449019 492414 472251 516402 471505 569155 562804 577794 581687 665381 548654 578472 596785 587527 598871 422862 399520 445363 513070 498064 531760 534732 617968 571657 818994 817364 716468 787955 730579 528146 145424 411729 445057 464283 508109 566170 573622 573714 684304 424023 90718 461568 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.78%) |
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 53992 90718 118282 145424 163429 399520 403421 411729 411742 418646 422862 424023 431452 435735 445057 445363 447105 447462 449019 461568 464283 468593 469898 471505 472251 473037 473322 476749 477980 479689 485673 491193 492414 498025 498064 508109 508894 513070 515215 516402 521225 528146 530959 531595 531760 534732 540864 545167 547373 548533 548654 551947 556379 559892 562513 562804 566047 566170 569155 571657 573062 573622 573684 573714 574247 577794 578472 581659 581687 581964 583594 584126 584666 587527 590436 595363 595451 596785 598871 607437 617968 624831 629954 631044 638623 649267 660761 665381 676927 676944 678218 684304 716468 722157 724903 727921 730579 735773 735785 737825 744037 744083 744095 748121 749533 753153 764758 764810 775313 787955 792198 793518 796362 797234 800619 809429 809724 813905 817364 818994 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18- молодые киски"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 молодые вагин"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.