Query Metrics
7
Database Queries
7
Different statements
163.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.54 ms (75.99%) |
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 193761 270386 381785 385958 387213 391482 392055 392600 394309 395729 397068 398830 400097 400209 400479 401861 401958 402534 402963 402972 402973 403588 403660 407109 407187 407567 409150 415488 416103 417921 418553 420351 420352 421491 421890 422171 422198 422199 425590 426765 428454 429492 431376 435579 442426 444707 446054 447917 449662 450764 450785 450847 451517 452320 453151 454040 457976 459515 462705 468719 468808 469180 469502 471403 472142 473505 475828 476534 477067 477230 478537 478937 480493 480518 481805 484446 484630 485061 485184 494269 497389 497779 500432 505771 505891 510251 511790 512794 515512 521136 523256 527000 527263 528829 531072 542594 547859 559439 566702 567416 570917 573754 578291 583457 589068 591415 591692 599353 600854 603255 604409 605642 607230 611730 613316 672506 705741 740985 742033 765834 ] |
||||||||||||||||||||||||||||||
|
25.55 ms (15.59%) |
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 468808 193761 270386 398830 425590 477067 452320 449662 462705 527263 542594 567416 400209 471403 450847 422171 422198 431376 527000 494269 531072 523256 583457 613316 607230 475828 421890 416103 497779 505891 528829 566702 573754 599353 589068 591415 603255 473505 477230 521136 385958 392055 400097 409150 421491 442426 444707 407187 415488 418553 429492 454040 451517 453151 469502 480493 481805 450764 459515 468719 547859 570917 578291 672506 705741 605642 611730 600854 740985 765834 742033 381785 391482 394309 397068 401861 402972 457976 469180 480518 387213 401958 402963 435579 392600 395729 402534 403660 407567 476534 478937 402973 428454 478537 417921 484446 505771 512794 515512 485184 497389 500432 511790 446054 450785 559439 591692 604409 403588 422199 426765 400479 407109 447917 472142 420352 420351 510251 484630 485061 ] |
||||||||||||||||||||||||||||||
|
6.42 ms (3.92%) |
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 193761 270386 381785 385958 387213 391482 392055 392600 394309 395729 397068 398830 400097 400209 400479 401861 401958 402534 402963 402972 402973 403588 403660 407109 407187 407567 409150 415488 416103 417921 418553 420351 420352 421491 421890 422171 422198 422199 425590 426765 428454 429492 431376 435579 442426 444707 446054 447917 449662 450764 450785 450847 451517 452320 453151 454040 457976 459515 462705 468719 468808 469180 469502 471403 472142 473505 475828 476534 477067 477230 478537 478937 480493 480518 481805 484446 484630 485061 485184 494269 497389 497779 500432 505771 505891 510251 511790 512794 515512 521136 523256 527000 527263 528829 531072 542594 547859 559439 566702 567416 570917 573754 578291 583457 589068 591415 591692 599353 600854 603255 604409 605642 607230 611730 613316 672506 705741 740985 742033 765834 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom bitch"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom женскийрод"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.