Query Metrics
7
Database Queries
7
Different statements
181.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.38 ms (81.16%) |
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 16971 307654 342206 358887 385296 385755 387537 388668 391450 392540 396600 400813 401006 404263 404693 410935 411203 413033 415077 415843 416752 420886 421094 421854 421954 422157 423940 424302 424366 424398 424530 427972 428569 430818 433110 433179 433253 433269 437864 437947 440538 443089 443278 444361 445586 445644 446112 446131 447523 447916 448507 451620 451877 452115 453162 454401 454931 455785 457419 457438 459961 463267 463858 464372 464487 464727 466198 466261 468442 468487 469444 470304 470903 472318 479082 479697 484664 485458 492609 493033 493584 496032 496615 499726 502487 502616 503115 504326 504906 506529 508473 508686 509855 513498 515186 520681 523354 526117 528297 534987 535447 549841 549870 555141 558420 561730 565156 570208 573461 596871 598739 598890 600489 609292 618923 621397 622932 659905 675798 680185 ] |
||||||||||||||||||||||||||||||
|
23.86 ms (13.14%) |
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 468442 496615 464727 307654 416752 411203 424366 485458 493584 506529 555141 400813 420886 466198 504906 503115 392540 433253 415077 437947 463267 558420 561730 421954 385755 401006 404263 447523 430818 448507 493033 484664 528297 535447 502616 472318 457419 415843 469444 459961 428569 479697 513498 455785 391450 499726 596871 452115 573461 470903 680185 437864 424398 526117 404693 424302 446131 445644 422157 444361 463858 443278 457438 504326 509855 410935 570208 598739 396600 534987 549870 427972 433269 446112 358887 443089 496032 492609 385296 342206 421094 451620 447916 464372 598890 413033 423940 445586 520681 675798 470304 388668 549841 609292 508686 523354 600489 468487 621397 424530 433110 440538 454931 433179 451877 421854 479082 16971 502487 515186 659905 565156 618923 622932 387537 453162 454401 508473 466261 464487 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (1.99%) |
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 16971 307654 342206 358887 385296 385755 387537 388668 391450 392540 396600 400813 401006 404263 404693 410935 411203 413033 415077 415843 416752 420886 421094 421854 421954 422157 423940 424302 424366 424398 424530 427972 428569 430818 433110 433179 433253 433269 437864 437947 440538 443089 443278 444361 445586 445644 446112 446131 447523 447916 448507 451620 451877 452115 453162 454401 454931 455785 457419 457438 459961 463267 463858 464372 464487 464727 466198 466261 468442 468487 469444 470304 470903 472318 479082 479697 484664 485458 492609 493033 493584 496032 496615 499726 502487 502616 503115 504326 504906 506529 508473 508686 509855 513498 515186 520681 523354 526117 528297 534987 535447 549841 549870 555141 558420 561730 565156 570208 573461 596871 598739 598890 600489 609292 618923 621397 622932 659905 675798 680185 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"суку в очко"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"женскийрод анал"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.75%) |
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.