Query Metrics
7
Database Queries
7
Different statements
193.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.03 ms (85.42%) |
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 12573 33401 111339 120074 382788 382912 386956 397958 401517 413999 415048 427759 429855 438279 446345 448705 454331 454844 458202 472804 477801 480357 483587 493001 496329 508070 509149 517299 519712 519766 528173 529318 540021 540528 543866 544694 545108 545359 545855 554867 560738 565098 575197 579195 584615 585807 587081 587959 590165 591162 591701 591999 593104 593120 601738 607478 608373 608516 616561 618845 621967 623963 624828 630712 630913 636326 637077 638477 640331 641003 643920 644307 647641 648279 648925 649168 651872 660365 662043 666850 674100 680242 693220 694100 695464 704185 708477 709885 710266 711337 718947 722488 725115 732293 735678 735848 737910 741527 744656 751309 755020 757480 768692 770115 783053 784703 785552 785580 788835 790815 793151 793923 796696 796871 799949 806103 807142 811696 812738 821162 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (8.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 543866 648925 647641 587959 793151 741527 448705 382912 454844 579195 751309 480357 111339 413999 821162 477801 528173 544694 545359 693220 694100 591999 643920 585807 624828 630712 755020 770115 757480 636326 33401 648279 644307 784703 584615 790815 735848 120074 560738 722488 618845 796696 641003 508070 540021 545855 708477 806103 735678 545108 591701 446345 382788 640331 587081 616561 793923 807142 788835 783053 666850 785580 621967 744656 12573 397958 649168 593120 493001 695464 718947 725115 709885 438279 415048 496329 529318 554867 601738 811696 732293 472804 517299 680242 429855 519712 386956 401517 427759 711337 662043 607478 608373 799949 483587 454331 519766 540528 565098 674100 710266 660365 704185 591162 590165 630913 638477 796871 768692 812738 458202 509149 623963 593104 608516 637077 785552 737910 575197 651872 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.01%) |
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 12573 33401 111339 120074 382788 382912 386956 397958 401517 413999 415048 427759 429855 438279 446345 448705 454331 454844 458202 472804 477801 480357 483587 493001 496329 508070 509149 517299 519712 519766 528173 529318 540021 540528 543866 544694 545108 545359 545855 554867 560738 565098 575197 579195 584615 585807 587081 587959 590165 591162 591701 591999 593104 593120 601738 607478 608373 608516 616561 618845 621967 623963 624828 630712 630913 636326 637077 638477 640331 641003 643920 644307 647641 648279 648925 649168 651872 660365 662043 666850 674100 680242 693220 694100 695464 704185 708477 709885 710266 711337 718947 722488 725115 732293 735678 735848 737910 741527 744656 751309 755020 757480 768692 770115 783053 784703 785552 785580 788835 790815 793151 793923 796696 796871 799949 806103 807142 811696 812738 821162 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black girl ass"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black девушк жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black девушк жоп"
]
|
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.