Query Metrics
7
Database Queries
7
Different statements
147.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.39 ms (83.78%) |
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 419196 420206 420301 424566 432766 434025 440634 446137 446614 447738 448704 448859 453551 455068 458929 459864 462091 466602 468688 468693 468776 473009 473019 474604 474691 483129 486509 495367 503220 512190 513645 522844 523548 527220 529854 536915 537831 539938 551112 564443 565473 569127 585133 590902 591955 596301 596347 600516 603219 603481 604009 605321 605345 609793 615539 621661 636794 638991 643936 653282 663958 663966 672881 673013 673445 676931 679713 689991 693301 696714 697299 705120 715710 717667 717942 718624 719117 720678 723547 724175 724703 726608 726677 727632 727767 730579 730854 733602 733603 735988 736066 737076 737093 741983 744508 746157 746979 747375 747476 747528 750920 751043 751768 751770 753104 754221 755401 755416 756171 762553 774079 774111 776523 779254 782676 782725 784841 785324 799266 808424 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.36%) |
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 569127 663966 673445 697299 672881 663958 696714 551112 615539 605321 779254 784841 782725 733602 735988 747528 782676 808424 724703 736066 737076 774111 724175 726677 750920 754221 762553 726608 727767 730579 733603 741983 751043 774079 432766 420301 440634 585133 447738 448704 448859 474604 474691 446614 455068 458929 466602 527220 468693 565473 596347 621661 419196 473009 459864 462091 468688 468776 424566 503220 483129 495367 486509 523548 529854 539938 564443 638991 605345 590902 420206 434025 723547 446137 537831 536915 512190 653282 676931 693301 715710 717667 673013 718624 719117 689991 705120 717942 596301 636794 591955 600516 604009 603219 643936 785324 727632 730854 737093 746157 751768 756171 746979 755416 744508 751770 755401 747375 747476 753104 603481 609793 720678 776523 799266 453551 513645 679713 473019 522844 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.75%) |
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 419196 420206 420301 424566 432766 434025 440634 446137 446614 447738 448704 448859 453551 455068 458929 459864 462091 466602 468688 468693 468776 473009 473019 474604 474691 483129 486509 495367 503220 512190 513645 522844 523548 527220 529854 536915 537831 539938 551112 564443 565473 569127 585133 590902 591955 596301 596347 600516 603219 603481 604009 605321 605345 609793 615539 621661 636794 638991 643936 653282 663958 663966 672881 673013 673445 676931 679713 689991 693301 696714 697299 705120 715710 717667 717942 718624 719117 720678 723547 724175 724703 726608 726677 727632 727767 730579 730854 733602 733603 735988 736066 737076 737093 741983 744508 746157 746979 747375 747476 747528 750920 751043 751768 751770 753104 754221 755401 755416 756171 762553 774079 774111 776523 779254 782676 782725 784841 785324 799266 808424 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting hair pussy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг hair pussy"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг hair pussy"
]
|
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.