Query Metrics
7
Database Queries
7
Different statements
189.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.39 ms (88.00%) |
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 61536 326944 331119 384268 385590 387018 389899 394376 404692 411182 415554 416191 418188 420202 428801 430468 431716 433229 435715 448640 450399 452513 457253 457980 458327 458617 458623 463739 463741 464949 468719 471628 472669 477407 495666 496107 510043 512205 512215 515749 516816 519291 522123 525178 532106 532109 533313 533499 535434 540186 542542 543888 545484 550618 551994 552028 554885 556428 556662 557812 557814 557823 558428 559852 559886 564791 564797 565468 565469 565991 565995 565998 566488 566491 581972 583667 585388 590934 590969 591849 595785 598344 600575 600626 601024 601081 601154 604844 605848 616612 619411 619487 623610 628167 641455 642064 653415 692682 726811 733911 747177 765967 771807 771823 774690 776911 785024 797202 805279 807641 808898 812657 815165 816360 820667 821536 823515 824416 825259 825906 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (6.07%) |
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 542542 771807 785024 559852 552028 583667 601081 825906 516816 428801 448640 389899 551994 535434 477407 776911 605848 619487 821536 496107 430468 384268 623610 326944 532109 550618 458623 385590 545484 774690 565998 825259 591849 565469 512215 556662 512205 458327 816360 495666 557814 557823 566488 585388 807641 771823 519291 457980 411182 418188 431716 566491 619411 457253 600626 601154 472669 387018 533313 733911 590934 543888 601024 823515 394376 525178 416191 533499 565991 616612 515749 581972 653415 765967 471628 590969 433229 815165 463741 595785 565468 464949 692682 604844 540186 805279 808898 404692 600575 415554 556428 450399 463739 458617 564791 642064 641455 565995 510043 598344 628167 522123 468719 331119 420202 452513 824416 532106 558428 564797 554885 797202 747177 435715 559886 726811 820667 812657 61536 557812 ] |
||||||||||||||||||||||||||||||
|
3.74 ms (1.98%) |
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 61536 326944 331119 384268 385590 387018 389899 394376 404692 411182 415554 416191 418188 420202 428801 430468 431716 433229 435715 448640 450399 452513 457253 457980 458327 458617 458623 463739 463741 464949 468719 471628 472669 477407 495666 496107 510043 512205 512215 515749 516816 519291 522123 525178 532106 532109 533313 533499 535434 540186 542542 543888 545484 550618 551994 552028 554885 556428 556662 557812 557814 557823 558428 559852 559886 564791 564797 565468 565469 565991 565995 565998 566488 566491 581972 583667 585388 590934 590969 591849 595785 598344 600575 600626 601024 601081 601154 604844 605848 616612 619411 619487 623610 628167 641455 642064 653415 692682 726811 733911 747177 765967 771807 771823 774690 776911 785024 797202 805279 807641 808898 812657 815165 816360 820667 821536 823515 824416 825259 825906 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк milf минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian milf минет"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"азиатк milf минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.