Query Metrics
7
Database Queries
7
Different statements
205.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.62 ms (87.58%) |
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 6965 143235 183074 191045 379600 382735 388474 391668 391926 394206 395460 397861 400191 400487 401480 404972 411182 411213 412875 413098 419144 420767 421871 422172 424180 424770 427115 428700 434358 439776 440076 441496 443807 444234 445236 445351 445530 448687 449020 449068 451112 452274 452886 454524 454943 455882 457279 459200 463779 467628 467897 467945 468687 469084 469092 469250 470446 472611 472639 476055 477128 478186 478261 478369 482522 483150 483346 484608 490106 500806 503113 504738 509024 514833 515511 515964 519047 519085 526556 530001 533655 544510 558718 562938 563072 571194 576622 582452 584073 590410 597018 604089 605129 669341 693089 693535 705479 710236 711628 715475 727560 733454 754649 756383 765367 769382 777750 781326 782027 792936 799641 799802 801175 807402 817878 818613 819190 819238 822045 822930 ] |
||||||||||||||||||||||||||||||
|
15.43 ms (7.52%) |
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 530001 451112 454524 412875 443807 822045 693535 819238 571194 605129 515511 472611 400487 404972 445236 584073 463779 413098 582452 483150 419144 422172 469084 452274 469092 449020 469250 590410 427115 454943 391926 183074 445351 769382 400191 388474 817878 756383 476055 391668 395460 401480 468687 478261 467945 482522 777750 727560 382735 394206 470446 490106 576622 562938 379600 439776 519047 484608 519085 801175 6965 428700 424770 526556 533655 754649 421871 799641 669341 445530 467897 478186 509024 503113 705479 765367 807402 143235 411213 715475 478369 799802 455882 693089 604089 444234 441496 467628 782027 452886 472639 792936 424180 477128 434358 500806 514833 397861 819190 457279 822930 558718 710236 711628 781326 733454 191045 420767 504738 448687 440076 459200 411182 818613 597018 449068 515964 483346 544510 563072 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.41%) |
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 6965 143235 183074 191045 379600 382735 388474 391668 391926 394206 395460 397861 400191 400487 401480 404972 411182 411213 412875 413098 419144 420767 421871 422172 424180 424770 427115 428700 434358 439776 440076 441496 443807 444234 445236 445351 445530 448687 449020 449068 451112 452274 452886 454524 454943 455882 457279 459200 463779 467628 467897 467945 468687 469084 469092 469250 470446 472611 472639 476055 477128 478186 478261 478369 482522 483150 483346 484608 490106 500806 503113 504738 509024 514833 515511 515964 519047 519085 526556 530001 533655 544510 558718 562938 563072 571194 576622 582452 584073 590410 597018 604089 605129 669341 693089 693535 705479 710236 711628 715475 727560 733454 754649 756383 765367 769382 777750 781326 782027 792936 799641 799802 801175 807402 817878 818613 819190 819238 822045 822930 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс с мамой и с девушкой"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс мам женщин девушк"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.