Query Metrics
7
Database Queries
7
Different statements
150.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.02 ms (83.25%) |
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 37980 74014 154694 161969 327965 365903 365945 365965 384050 385712 386996 388570 392030 393615 401774 410193 419543 419557 420700 422365 422488 424007 424280 428360 440651 443690 443713 443740 444126 444150 445053 447570 448227 453655 454155 454660 455328 459068 461950 462157 464523 464652 466459 466777 466935 470042 470195 470630 470644 472008 472804 472807 473975 474214 474220 474376 475602 476388 477008 477733 477927 478161 479624 480235 483494 485408 485945 485983 485986 491071 494398 498130 499051 501130 510630 510828 511057 512145 512658 513691 525515 526837 527823 533733 535938 544065 548601 551813 553621 558686 562330 562426 570326 570373 570669 573711 574076 586638 597040 603744 655081 656071 730031 731581 733651 736058 742144 742932 743105 745344 747711 764057 764060 781489 787543 796262 805615 805666 819268 821805 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (10.64%) |
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 743105 730031 742144 745344 764057 742932 747711 764060 731581 733651 736058 781489 805666 74014 384050 385712 393615 470042 476388 392030 440651 365945 388570 443713 447570 485945 494398 603744 424280 464523 410193 443690 461950 474220 485986 513691 485408 535938 444126 419557 466459 470644 479624 466777 558686 562426 570669 443740 455328 462157 464652 420700 445053 477008 477927 478161 422365 454155 454660 472807 453655 472008 472804 475602 511057 526837 483494 485983 527823 327965 570373 656071 562330 570326 37980 386996 401774 419543 428360 512658 510630 805615 796262 533733 491071 597040 154694 473975 448227 422488 821805 655081 787543 161969 365965 365903 424007 819268 466935 470630 501130 480235 551813 574076 573711 544065 548601 553621 586638 470195 474376 477733 459068 474214 444150 525515 499051 510828 512145 498130 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.61%) |
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 37980 74014 154694 161969 327965 365903 365945 365965 384050 385712 386996 388570 392030 393615 401774 410193 419543 419557 420700 422365 422488 424007 424280 428360 440651 443690 443713 443740 444126 444150 445053 447570 448227 453655 454155 454660 455328 459068 461950 462157 464523 464652 466459 466777 466935 470042 470195 470630 470644 472008 472804 472807 473975 474214 474220 474376 475602 476388 477008 477733 477927 478161 479624 480235 483494 485408 485945 485983 485986 491071 494398 498130 499051 501130 510630 510828 511057 512145 512658 513691 525515 526837 527823 533733 535938 544065 548601 551813 553621 558686 562330 562426 570326 570373 570669 573711 574076 586638 597040 603744 655081 656071 730031 731581 733651 736058 742144 742932 743105 745344 747711 764057 764060 781489 787543 796262 805615 805666 819268 821805 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits russian"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ русск"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ русск"
]
|
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.