Query Metrics
7
Database Queries
7
Different statements
186.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.46 ms (86.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 4463 13229 74434 146508 152157 181009 187843 188064 188338 191330 213330 213429 232953 232973 233049 233135 233321 252068 326115 377323 382419 384268 384340 385314 385632 386991 387711 391492 391704 391705 394420 397023 397878 398933 400819 401960 404587 405491 408354 409877 409932 409935 410732 411914 412273 419543 424439 424472 427433 428475 428539 443154 443777 446630 460913 470965 474465 474794 474846 477455 517589 520892 532051 532062 534221 537548 542957 549837 557514 561453 562013 562961 563433 565146 570909 594767 605460 605666 623145 663466 663861 666970 674556 702455 702904 702978 710593 714504 717683 717689 720121 725570 734309 740826 742656 744321 746621 748231 753707 765299 766663 770494 774314 781696 788151 788277 788868 789537 789691 804112 805199 805266 805685 807452 808438 808556 811923 813924 823686 824014 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (7.98%) |
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 717689 549837 788151 808556 387711 233049 460913 424472 397878 477455 232953 605666 789691 742656 4463 394420 252068 377323 233135 443154 187843 409932 748231 424439 474846 517589 663466 605460 720121 443777 537548 382419 823686 824014 534221 570909 702904 717683 702455 563433 565146 623145 805266 804112 805199 766663 774314 702978 714504 805685 74434 391705 391492 191330 562961 789537 807452 746621 811923 232973 13229 384268 405491 408354 813924 532051 562013 666970 710593 663861 674556 594767 808438 734309 744321 753707 781696 386991 397023 213429 213330 419543 385632 233321 385314 152157 188064 326115 404587 409877 428539 411914 412273 427433 474794 474465 446630 532062 542957 557514 561453 770494 788868 740826 725570 765299 788277 188338 398933 391704 400819 409935 470965 384340 181009 401960 410732 428475 520892 146508 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.44%) |
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 4463 13229 74434 146508 152157 181009 187843 188064 188338 191330 213330 213429 232953 232973 233049 233135 233321 252068 326115 377323 382419 384268 384340 385314 385632 386991 387711 391492 391704 391705 394420 397023 397878 398933 400819 401960 404587 405491 408354 409877 409932 409935 410732 411914 412273 419543 424439 424472 427433 428475 428539 443154 443777 446630 460913 470965 474465 474794 474846 477455 517589 520892 532051 532062 534221 537548 542957 549837 557514 561453 562013 562961 563433 565146 570909 594767 605460 605666 623145 663466 663861 666970 674556 702455 702904 702978 710593 714504 717683 717689 720121 725570 734309 740826 742656 744321 746621 748231 753707 765299 766663 770494 774314 781696 788151 788277 788868 789537 789691 804112 805199 805266 805685 807452 808438 808556 811923 813924 823686 824014 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old mother"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мам женщин"
]
|
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.