Query Metrics
7
Database Queries
7
Different statements
153.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.01 ms (80.38%) |
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 118109 389680 389973 391202 391938 426531 439484 443787 449375 450368 452312 453107 455872 457001 460761 462210 462307 462522 465353 465354 466835 472638 473527 475968 476637 477376 478937 479040 482270 482339 485960 486583 489299 489847 491116 494735 496862 496874 502868 505959 506466 508729 509206 511495 513624 517723 518756 518901 519361 522711 523662 546930 546953 547868 555379 565303 572350 577096 581363 583655 586445 591888 603890 604958 606618 612060 615516 615525 621217 623035 688083 696308 707429 722018 723469 725825 726003 726468 726595 726707 727757 727857 728440 728506 729217 729989 733085 733091 733227 737130 738327 742902 746679 748113 755447 787155 787387 788944 790976 795055 795143 797260 797914 800392 803076 803712 805694 807327 807352 809372 814399 816052 817809 819403 819410 823760 824364 824459 826489 827269 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (11.83%) |
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 426531 546930 443787 824364 473527 457001 466835 707429 723469 738327 506466 728506 494735 788944 472638 726595 391202 439484 621217 742902 604958 803712 733085 612060 696308 450368 577096 797914 733227 819410 508729 572350 787387 478937 615525 807327 462307 465353 479040 496874 746679 688083 509206 755447 623035 826489 795055 797260 555379 486583 819403 800392 727757 489299 518756 462210 391938 583655 728440 502868 518901 453107 505959 725825 475968 726707 546953 729989 581363 118109 547868 606618 591888 795143 727857 726003 615516 452312 513624 485960 519361 389973 482339 449375 603890 389680 489847 517723 816052 787155 807352 803076 460761 817809 455872 748113 482270 491116 805694 726468 522711 823760 824459 722018 586445 790976 462522 476637 465354 496862 511495 523662 809372 477376 737130 814399 565303 733091 827269 729217 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (2.40%) |
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 118109 389680 389973 391202 391938 426531 439484 443787 449375 450368 452312 453107 455872 457001 460761 462210 462307 462522 465353 465354 466835 472638 473527 475968 476637 477376 478937 479040 482270 482339 485960 486583 489299 489847 491116 494735 496862 496874 502868 505959 506466 508729 509206 511495 513624 517723 518756 518901 519361 522711 523662 546930 546953 547868 555379 565303 572350 577096 581363 583655 586445 591888 603890 604958 606618 612060 615516 615525 621217 623035 688083 696308 707429 722018 723469 725825 726003 726468 726595 726707 727757 727857 728440 728506 729217 729989 733085 733091 733227 737130 738327 742902 746679 748113 755447 787155 787387 788944 790976 795055 795143 797260 797914 800392 803076 803712 805694 807327 807352 809372 814399 816052 817809 819403 819410 823760 824364 824459 826489 827269 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин лиза жен"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"зрелая женщин лиза жен"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.