Query Metrics
7
Database Queries
7
Different statements
168.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.19 ms (83.78%) |
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 96665 355294 381835 381929 385653 401876 402599 407305 407359 407750 407777 409076 410177 413731 413958 418125 419521 420016 422277 424296 424452 425279 427203 432641 433351 439475 439521 439784 440292 440963 444234 449038 450635 451991 452249 453449 454186 454260 455201 457457 457631 458110 459070 459646 460179 460187 460190 460645 460908 461057 464215 464352 464490 466222 466224 466240 466756 468635 468900 469126 469364 470007 470027 470695 472698 473315 473806 475660 475676 475878 476176 477716 479123 483338 483364 483632 484369 485701 489016 489384 490923 513670 513992 517534 519358 519359 524268 539503 549850 551529 554525 555062 556467 557340 563427 564263 570948 577420 583532 583534 593057 596415 599438 602165 602974 617956 644222 697181 718041 734204 738226 768851 788120 797250 797274 804254 804352 805538 810297 810317 ] |
||||||||||||||||||||||||||||||
|
17.27 ms (10.25%) |
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 644222 810317 797274 738226 718041 804254 804352 407359 424296 473315 469126 464490 401876 452249 420016 513670 451991 602974 439521 466240 439784 457457 477716 381835 407777 439475 454186 460187 460645 468635 473806 453449 466222 513992 472698 475660 475676 556467 549850 555062 557340 563427 564263 602165 810297 407750 424452 433351 460190 476176 449038 454260 460179 460908 407305 418125 464352 385653 419521 468900 450635 519358 483338 483632 484369 489016 489384 490923 483364 485701 519359 96665 355294 402599 409076 413958 425279 432641 413731 410177 427203 422277 440292 440963 459646 469364 470695 458110 470027 455201 466224 539503 517534 524268 464215 551529 583534 570948 554525 577420 583532 617956 596415 593057 599438 788120 797250 734204 805538 768851 697181 381929 444234 466756 479123 461057 457631 459070 475878 470007 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.52%) |
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 96665 355294 381835 381929 385653 401876 402599 407305 407359 407750 407777 409076 410177 413731 413958 418125 419521 420016 422277 424296 424452 425279 427203 432641 433351 439475 439521 439784 440292 440963 444234 449038 450635 451991 452249 453449 454186 454260 455201 457457 457631 458110 459070 459646 460179 460187 460190 460645 460908 461057 464215 464352 464490 466222 466224 466240 466756 468635 468900 469126 469364 470007 470027 470695 472698 473315 473806 475660 475676 475878 476176 477716 479123 483338 483364 483632 484369 485701 489016 489384 490923 513670 513992 517534 519358 519359 524268 539503 549850 551529 554525 555062 556467 557340 563427 564263 570948 577420 583532 583534 593057 596415 599438 602165 602974 617956 644222 697181 718041 734204 738226 768851 788120 797250 797274 804254 804352 805538 810297 810317 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature naked"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature голые"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.86%) |
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.