Query Metrics
7
Database Queries
7
Different statements
178.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.51 ms (85.42%) |
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 424831 462829 466316 466481 477578 486396 491493 510284 539586 542273 542333 542338 542817 542849 543074 543137 543176 543193 543200 543286 543435 543461 543510 543527 543795 544682 547684 549143 549151 549998 550242 550244 550689 556935 556950 561452 562355 565925 565967 574985 576857 577066 583216 586457 586478 586511 586528 588426 591597 591683 602356 604098 604840 617116 620047 622922 623633 632119 635182 637122 643975 650782 660069 660806 669239 674650 676155 687512 687552 687564 687572 687608 688268 688299 702154 709439 713085 718153 726130 728238 732051 733136 737138 737890 748084 752516 767076 773840 775110 775126 789714 790007 797113 797124 807381 813738 818184 818692 818722 818922 818933 824878 825050 825338 825342 825408 825446 825951 825952 825970 826011 826062 826123 826174 826281 826438 826440 826996 828107 828335 ] |
||||||||||||||||||||||||||||||
|
14.04 ms (7.86%) |
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 542849 543527 543435 542817 543286 543795 556935 650782 586478 591683 462829 583216 556950 586511 632119 549143 826011 825338 543461 637122 486396 466481 491493 550689 602356 826123 825050 748084 543137 825951 424831 577066 617116 818184 825970 826174 813738 824878 825342 622922 773840 510284 586457 825408 825446 818922 818933 828335 828107 549998 549151 643975 565925 737890 543074 733136 826062 818692 826440 826281 826438 544682 543510 687608 674650 687564 635182 807381 752516 669239 543193 586528 542333 790007 797124 775110 797113 732051 466316 565967 543200 718153 687512 688299 702154 623633 767076 542273 676155 728238 737138 713085 826996 775126 789714 562355 561452 620047 477578 550242 550244 688268 687572 604840 726130 818722 825952 539586 542338 543176 547684 574985 576857 660806 687552 660069 709439 591597 604098 588426 ] |
||||||||||||||||||||||||||||||
|
4.41 ms (2.47%) |
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 424831 462829 466316 466481 477578 486396 491493 510284 539586 542273 542333 542338 542817 542849 543074 543137 543176 543193 543200 543286 543435 543461 543510 543527 543795 544682 547684 549143 549151 549998 550242 550244 550689 556935 556950 561452 562355 565925 565967 574985 576857 577066 583216 586457 586478 586511 586528 588426 591597 591683 602356 604098 604840 617116 620047 622922 623633 632119 635182 637122 643975 650782 660069 660806 669239 674650 676155 687512 687552 687564 687572 687608 688268 688299 702154 709439 713085 718153 726130 728238 732051 733136 737138 737890 748084 752516 767076 773840 775110 775126 789714 790007 797113 797124 807381 813738 818184 818692 818722 818922 818933 824878 825050 825338 825342 825408 825446 825951 825952 825970 826011 826062 826123 826174 826281 826438 826440 826996 828107 828335 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs arab"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs араб"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs араб"
]
|
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.