Query Metrics
7
Database Queries
7
Different statements
373.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.03 ms (57.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член old young"
]
|
||||||||||||||||||||||||||||||
|
134.67 ms (36.07%) |
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 58313 384967 386207 386686 393430 399445 412554 420111 427301 447195 454251 473018 484474 484648 510022 513739 515167 517589 522845 523328 537182 537845 548092 548833 554134 557274 559205 575685 592812 599716 605526 614849 618893 621288 621536 623346 623851 626844 646911 648513 659637 663877 664274 664831 664845 664857 665255 665342 665476 666754 669783 672322 673297 673547 677699 692859 693074 694122 704875 708821 712809 718399 721784 724479 727399 728008 730404 731416 731914 732873 742695 743138 746459 748675 748684 755252 755924 756080 758311 762414 771365 773084 775993 776025 777641 780446 782664 785021 785848 790981 793529 794238 798686 799004 799309 799310 799441 799632 800249 803345 804689 805059 807183 808649 808930 810553 812089 814082 817618 817652 820261 820690 821738 822235 822289 822419 824050 825119 825760 826800 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (4.27%) |
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 626844 605526 728008 386686 484474 548092 692859 664845 621536 822235 727399 731416 669783 742695 513739 384967 793529 517589 820261 771365 484648 510022 817618 559205 694122 785848 776025 777641 794238 800249 812089 799632 773084 454251 515167 782664 758311 672322 799441 755252 704875 386207 618893 393430 756080 663877 665342 664857 724479 412554 399445 473018 592812 522845 814082 820690 822289 825760 575685 665476 677699 659637 708821 664274 666754 673297 623851 614849 623346 775993 785021 805059 743138 807183 808930 810553 731914 762414 732873 804689 599716 537845 665255 648513 817652 746459 548833 825119 693074 554134 748684 427301 822419 821738 621288 798686 755924 664831 799004 557274 58313 447195 673547 420111 721784 718399 748675 808649 523328 824050 826800 537182 646911 712809 780446 790981 799309 799310 730404 803345 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (0.77%) |
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 58313 384967 386207 386686 393430 399445 412554 420111 427301 447195 454251 473018 484474 484648 510022 513739 515167 517589 522845 523328 537182 537845 548092 548833 554134 557274 559205 575685 592812 599716 605526 614849 618893 621288 621536 623346 623851 626844 646911 648513 659637 663877 664274 664831 664845 664857 665255 665342 665476 666754 669783 672322 673297 673547 677699 692859 693074 694122 704875 708821 712809 718399 721784 724479 727399 728008 730404 731416 731914 732873 742695 743138 746459 748675 748684 755252 755924 756080 758311 762414 771365 773084 775993 776025 777641 780446 782664 785021 785848 790981 793529 794238 798686 799004 799309 799310 799441 799632 800249 803345 804689 805059 807183 808649 808930 810553 812089 814082 817618 817652 820261 820690 821738 822235 822289 822419 824050 825119 825760 826800 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob old young"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член old young"
]
|
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.