Query Metrics
7
Database Queries
7
Different statements
574.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
422.72 ms (73.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп milf анал"
]
|
||||||||||||||||||||||||||||||
|
129.14 ms (22.49%) |
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 124345 388891 391694 393856 394652 401201 415313 425924 427543 430542 433507 436937 439746 440801 443247 446989 448656 451022 462849 465540 467914 473400 483630 486365 492009 495336 497509 531571 534636 534801 535052 535447 536424 536456 544161 544988 545669 549221 550899 558897 560867 560905 563096 565909 567994 591944 591977 596408 596796 615511 646290 655900 660403 663337 699415 701763 705640 710250 710460 713500 717193 726960 728266 728393 731327 734380 735459 736242 736249 736692 738476 739294 740115 742740 749330 749891 752759 756236 760999 761019 761199 761600 761784 767116 767203 773912 775543 782294 783042 783369 783425 784162 791416 793138 793867 794765 794767 796194 796319 798688 798804 800469 800582 802144 802620 803046 804237 804810 810297 810323 813828 817456 818274 821005 823611 825418 827037 827589 828773 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (2.44%) |
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 817456 827037 818274 401201 761600 726960 451022 825418 804237 393856 394652 827589 701763 734380 743671 783369 443247 558897 560867 440801 486365 710460 783425 761199 738476 735459 802620 124345 465540 736249 565909 749330 615511 534801 497509 550899 596796 740115 736692 752759 756236 767116 425924 534636 803046 761784 760999 710250 660403 591944 796194 739294 705640 791416 436937 536424 563096 800582 802144 596408 427543 813828 821005 828773 531571 545669 567994 544161 717193 793867 783042 784162 798688 800469 804810 767203 736242 728266 728393 749891 782294 798804 448656 433507 536456 473400 439746 535447 483630 415313 560905 591977 810297 467914 446989 430542 549221 462849 388891 495336 544988 663337 646290 713500 775543 794765 773912 731327 699415 793138 655900 761019 823611 535052 794767 796319 742740 810323 492009 391694 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.54%) |
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 124345 388891 391694 393856 394652 401201 415313 425924 427543 430542 433507 436937 439746 440801 443247 446989 448656 451022 462849 465540 467914 473400 483630 486365 492009 495336 497509 531571 534636 534801 535052 535447 536424 536456 544161 544988 545669 549221 550899 558897 560867 560905 563096 565909 567994 591944 591977 596408 596796 615511 646290 655900 660403 663337 699415 701763 705640 710250 710460 713500 717193 726960 728266 728393 731327 734380 735459 736242 736249 736692 738476 739294 740115 742740 749330 749891 752759 756236 760999 761019 761199 761600 761784 767116 767203 773912 775543 782294 783042 783369 783425 784162 791416 793138 793867 794765 794767 796194 796319 798688 798804 800469 800582 802144 802620 803046 804237 804810 810297 810323 813828 817456 818274 821005 823611 825418 827037 827589 828773 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big-ass-milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп milf анал"
]
|
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.