Query Metrics
7
Database Queries
7
Different statements
217.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.17 ms (89.72%) |
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 85250 118227 154123 187992 293121 382898 387047 387145 388740 397080 397937 401491 411072 411811 412855 415741 419998 420333 420431 434364 452946 454338 459633 467114 468277 468357 468508 469305 469508 471028 472196 475028 475137 475727 475901 476163 478633 479832 484234 486784 487556 491102 495602 496009 504016 510945 511376 512465 513629 514023 526717 533655 541845 541858 542739 547927 555267 564301 566767 583539 585214 604153 605285 611171 615827 632112 660851 680284 686158 715813 724123 724523 725205 727741 728262 729247 729291 731349 733548 738018 753772 754649 756666 756677 759566 759921 759931 765616 765723 765792 768764 769131 773271 776121 778133 778215 782027 782122 784209 785107 785495 791883 792539 794895 795763 795916 796119 798696 800582 800721 801253 801398 802093 802160 809648 810308 823731 824615 827431 827632 ] |
||||||||||||||||||||||||||||||
|
12.47 ms (5.73%) |
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 604153 615827 776121 791883 769131 154123 434364 511376 387047 472196 475028 491102 585214 475901 555267 773271 823731 725205 795763 798696 768764 513629 401491 759931 794895 796119 467114 476163 547927 827431 459633 680284 715813 583539 802160 738018 765616 782122 785495 733548 724123 759566 795916 475727 827632 778133 784209 756666 724523 728262 778215 475137 542739 420431 411072 415741 479832 484234 512465 471028 660851 468508 487556 514023 469305 478633 468277 454338 510945 495602 541845 541858 605285 382898 496009 526717 801398 504016 452946 802093 782027 387145 611171 792539 753772 809648 419998 824615 533655 566767 564301 754649 765792 729291 765723 756677 731349 397080 388740 632112 759921 727741 411811 293121 118227 187992 810308 85250 468357 412855 469508 486784 420333 397937 729247 686158 785107 800582 800721 801253 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.25%) |
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 85250 118227 154123 187992 293121 382898 387047 387145 388740 397080 397937 401491 411072 411811 412855 415741 419998 420333 420431 434364 452946 454338 459633 467114 468277 468357 468508 469305 469508 471028 472196 475028 475137 475727 475901 476163 478633 479832 484234 486784 487556 491102 495602 496009 504016 510945 511376 512465 513629 514023 526717 533655 541845 541858 542739 547927 555267 564301 566767 583539 585214 604153 605285 611171 615827 632112 660851 680284 686158 715813 724123 724523 725205 727741 728262 729247 729291 731349 733548 738018 753772 754649 756666 756677 759566 759921 759931 765616 765723 765792 768764 769131 773271 776121 778133 778215 782027 782122 784209 785107 785495 791883 792539 794895 795763 795916 796119 798696 800582 800721 801253 801398 802093 802160 809648 810308 823731 824615 827431 827632 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam mother"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.78%) |
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.