Query Metrics
7
Database Queries
7
Different statements
180.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.50 ms (87.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 80332 95788 96933 97231 241603 346150 346188 384923 386336 386535 386567 388094 389519 389791 390305 390746 390956 391326 391978 392477 392721 392817 393743 393765 394004 394597 395472 396568 396701 396780 397027 397739 398384 398715 400592 402032 403060 404212 404470 409795 411744 411820 414271 415313 418351 421264 423428 441849 442157 445406 470020 476296 478779 491368 492484 515559 526223 528939 531268 532658 532741 534386 534567 534664 538253 539239 543389 544835 550264 550929 556331 556476 560417 561273 597251 597275 605378 619281 620487 626399 629832 631209 633444 634161 639810 647979 666549 666897 668537 674087 677986 678066 678067 678144 678600 680179 693502 704352 719765 723094 725627 731200 735345 744163 747151 757061 757905 770117 773885 780040 782091 788093 792395 800031 801925 802297 809225 811926 812562 ] |
||||||||||||||||||||||||||||||
|
11.87 ms (6.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 811926 780040 792395 731200 788093 762121 770117 773885 725627 757061 723094 801925 812562 391978 402032 384923 398384 411744 392721 392817 397739 404470 704352 241603 394597 390956 391326 396701 396780 396568 397027 409795 421264 442157 411820 423428 445406 492484 491368 515559 476296 556331 556476 543389 693502 719765 668537 680179 619281 597251 634161 597275 809225 800031 747151 757905 393765 441849 386535 393743 526223 647979 639810 631209 560417 802297 398715 400592 418351 538253 550929 674087 550264 620487 403060 390746 96933 404212 470020 80332 414271 478779 534386 561273 544835 626399 605378 782091 389519 528939 539239 532741 534567 534664 532658 678067 678144 677986 666549 666897 678066 633444 531268 735345 744163 678600 629832 386336 386567 394004 392477 395472 346150 346188 97231 95788 389791 388094 390305 415313 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.64%) |
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 80332 95788 96933 97231 241603 346150 346188 384923 386336 386535 386567 388094 389519 389791 390305 390746 390956 391326 391978 392477 392721 392817 393743 393765 394004 394597 395472 396568 396701 396780 397027 397739 398384 398715 400592 402032 403060 404212 404470 409795 411744 411820 414271 415313 418351 421264 423428 441849 442157 445406 470020 476296 478779 491368 492484 515559 526223 528939 531268 532658 532741 534386 534567 534664 538253 539239 543389 544835 550264 550929 556331 556476 560417 561273 597251 597275 605378 619281 620487 626399 629832 631209 633444 634161 639810 647979 666549 666897 668537 674087 677986 678066 678067 678144 678600 680179 693502 704352 719765 723094 725627 731200 735345 744163 747151 757061 757905 770117 773885 780040 782091 788093 792395 800031 801925 802297 809225 811926 812562 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кончает жестко"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.92%) |
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.