Query Metrics
7
Database Queries
7
Different statements
165.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.59 ms (81.88%) |
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 152508 191420 382045 382066 382657 385007 385603 385606 387230 387407 388200 388203 388329 388714 388784 389582 390643 395271 395998 397479 407359 408433 409942 413279 414072 415557 420257 428374 443690 444255 453096 453269 453270 465390 467896 474441 476303 480490 481871 484738 485701 486478 505690 523603 530013 530327 541180 551065 554322 555937 561575 563127 565679 580391 586617 588084 592723 604885 604941 609248 621337 629954 645840 663461 664809 665312 665483 665890 668181 680704 685910 702158 714156 715450 716245 718500 718559 718981 720583 721095 726588 726902 728443 731686 739955 743811 745379 745951 746783 759761 766669 770108 770178 770913 771379 772120 774187 774200 780634 781970 789528 789552 797278 799971 802076 803498 805362 808015 808496 808500 808506 808549 811401 823857 823915 824023 824171 824937 826346 826655 ] |
||||||||||||||||||||||||||||||
|
20.27 ms (12.24%) |
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 746783 385606 811401 395998 805362 770108 414072 408433 530327 802076 481871 586617 382066 685910 523603 530013 382045 604885 476303 561575 771379 387407 191420 555937 407359 453269 551065 592723 420257 385007 505690 629954 387230 397479 453270 716245 152508 541180 415557 474441 745951 480490 485701 428374 604941 467896 580391 486478 609248 565679 389582 823857 388203 743811 563127 409942 824171 726902 554322 780634 739955 774200 385603 388200 395271 824023 823915 680704 797278 388714 789528 718559 664809 781970 770913 721095 443690 766669 718500 663461 799971 465390 444255 453096 718981 668181 621337 803498 808549 772120 808496 770178 388784 413279 824937 588084 789552 484738 826655 665890 702158 714156 808015 726588 731686 759761 728443 808500 808506 826346 720583 774187 390643 665483 645840 382657 388329 665312 715450 745379 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.45%) |
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 152508 191420 382045 382066 382657 385007 385603 385606 387230 387407 388200 388203 388329 388714 388784 389582 390643 395271 395998 397479 407359 408433 409942 413279 414072 415557 420257 428374 443690 444255 453096 453269 453270 465390 467896 474441 476303 480490 481871 484738 485701 486478 505690 523603 530013 530327 541180 551065 554322 555937 561575 563127 565679 580391 586617 588084 592723 604885 604941 609248 621337 629954 645840 663461 664809 665312 665483 665890 668181 680704 685910 702158 714156 715450 716245 718500 718559 718981 720583 721095 726588 726902 728443 731686 739955 743811 745379 745951 746783 759761 766669 770108 770178 770913 771379 772120 774187 774200 780634 781970 789528 789552 797278 799971 802076 803498 805362 808015 808496 808500 808506 808549 811401 823857 823915 824023 824171 824937 826346 826655 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature tits"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature сиськ"
]
|
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.