Query Metrics
7
Database Queries
7
Different statements
203.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.07 ms (88.19%) |
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 19164 145053 145757 384368 386099 396364 398461 398979 400728 402419 414782 415430 418268 419839 426006 430227 431471 449335 450108 458987 471057 484102 492328 510946 511356 539770 541479 550367 551979 560409 563036 563683 563687 567422 575865 577561 584921 585240 587958 588615 590730 599228 605686 607692 607996 609058 609072 609551 614789 614843 614844 619791 624788 630649 640880 651563 660807 665372 667851 667942 675341 704992 710570 713115 715420 715444 716911 726831 726986 727545 730159 730813 733227 733266 733317 736077 736714 738058 739749 744197 744200 744209 744994 750627 751507 758799 769448 770090 770112 781972 783355 788226 793524 794196 796494 796614 797352 800054 800611 800712 800728 801804 804432 808480 812055 813202 814404 817262 817784 818396 819396 823606 824224 824732 825959 826455 826594 826892 827138 827648 ] |
||||||||||||||||||||||||||||||
|
12.42 ms (6.12%) |
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 563687 575865 667851 715420 713115 609551 800611 808480 788226 801804 804432 739749 614844 710570 796494 813202 19164 826594 818396 800054 145053 471057 563683 584921 563036 605686 630649 758799 449335 704992 727545 733266 733317 744994 386099 400728 588615 145757 384368 511356 819396 827138 824224 783355 430227 590730 793524 750627 450108 769448 560409 550367 585240 398461 539770 567422 551979 665372 587958 607692 609058 609072 624788 599228 619791 607996 614843 797352 812055 730159 736077 726831 730813 744209 738058 744197 744200 751507 781972 414782 510946 826892 660807 667942 675341 726986 398979 794196 541479 825959 817784 770090 817262 418268 484102 651563 716911 827648 492328 431471 715444 640880 796614 824732 577561 396364 419839 458987 415430 402419 823606 826455 614789 800712 800728 736714 770112 426006 814404 733227 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.29%) |
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 19164 145053 145757 384368 386099 396364 398461 398979 400728 402419 414782 415430 418268 419839 426006 430227 431471 449335 450108 458987 471057 484102 492328 510946 511356 539770 541479 550367 551979 560409 563036 563683 563687 567422 575865 577561 584921 585240 587958 588615 590730 599228 605686 607692 607996 609058 609072 609551 614789 614843 614844 619791 624788 630649 640880 651563 660807 665372 667851 667942 675341 704992 710570 713115 715420 715444 716911 726831 726986 727545 730159 730813 733227 733266 733317 736077 736714 738058 739749 744197 744200 744209 744994 750627 751507 758799 769448 770090 770112 781972 783355 788226 793524 794196 796494 796614 797352 800054 800611 800712 800728 801804 804432 808480 812055 813202 814404 817262 817784 818396 819396 823606 824224 824732 825959 826455 826594 826892 827138 827648 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая pussy жоп"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy pussy ass"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая 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.