Query Metrics
7
Database Queries
7
Different statements
201.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.99 ms (87.22%) |
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 129640 388726 390841 397863 399926 400494 420352 422184 423500 426532 439078 439738 445401 447253 448354 452115 452642 460412 462926 462930 464341 465222 465531 466241 466278 469560 469766 470459 470505 470647 470953 472154 472774 476729 477496 480387 481878 481964 482620 483639 486539 491276 493391 502762 503113 503413 505504 506278 509043 511826 514652 515776 518486 518583 518918 521204 521992 522627 522759 522914 526515 531073 531438 533443 534215 535264 535436 536939 538703 541359 541887 544665 549826 554854 558622 564337 569000 577354 581997 583913 584642 587142 588280 589651 591130 592573 598279 600007 600394 604310 604336 614957 615741 615744 620575 635081 642677 665328 673791 682145 695117 697308 697459 725206 736770 739659 747137 766738 771033 776544 785498 788184 790843 801292 814849 814892 815410 815490 815598 820995 ] |
||||||||||||||||||||||||||||||
|
16.19 ms (8.02%) |
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 614957 589651 592573 600394 591130 776544 725206 400494 447253 518486 503113 452115 531438 697308 635081 466241 531073 518918 522627 554854 588280 536939 483639 486539 388726 439078 423500 445401 815410 814849 815598 820995 472774 538703 533443 470647 541887 577354 673791 697459 695117 600007 642677 604310 620575 788184 739659 766738 801292 736770 771033 785498 464341 399926 129640 390841 493391 465531 511826 514652 518583 469560 564337 682145 615741 587142 615744 462926 470953 422184 503413 491276 535436 604336 747137 469766 583913 426532 814892 481878 448354 452642 535264 460412 462930 558622 569000 549826 481964 480387 420352 465222 470459 509043 534215 544665 476729 526515 522914 521204 581997 584642 598279 439738 506278 522759 505504 665328 521992 515776 541359 790843 502762 397863 815490 482620 466278 470505 472154 477496 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.39%) |
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 129640 388726 390841 397863 399926 400494 420352 422184 423500 426532 439078 439738 445401 447253 448354 452115 452642 460412 462926 462930 464341 465222 465531 466241 466278 469560 469766 470459 470505 470647 470953 472154 472774 476729 477496 480387 481878 481964 482620 483639 486539 491276 493391 502762 503113 503413 505504 506278 509043 511826 514652 515776 518486 518583 518918 521204 521992 522627 522759 522914 526515 531073 531438 533443 534215 535264 535436 536939 538703 541359 541887 544665 549826 554854 558622 564337 569000 577354 581997 583913 584642 587142 588280 589651 591130 592573 598279 600007 600394 604310 604336 614957 615741 615744 620575 635081 642677 665328 673791 682145 695117 697308 697459 725206 736770 739659 747137 766738 771033 776544 785498 788184 790843 801292 814849 814892 815410 815490 815598 820995 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"туалет анал milf"
]
|
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.