Query Metrics
7
Database Queries
7
Different statements
199.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.67 ms (87.49%) |
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 187268 247381 294327 389257 391592 391653 391980 394737 396780 397998 404483 411330 411347 424084 424517 426294 430134 451464 453072 453153 453244 453767 457420 461031 466201 469314 472568 474116 474851 483628 483639 485697 490402 496887 500874 506931 509599 511510 512138 514902 518855 521270 523034 523241 525507 525508 527140 530013 530270 531799 532019 534255 534258 536939 542285 545905 547009 549250 549652 549826 559040 561529 561572 563036 563656 564191 565732 566363 572303 577388 577572 579707 583096 584136 586360 587896 591272 591317 597849 600799 601134 604412 604556 607673 618622 641115 643380 651887 658470 664972 673651 677892 687430 695386 701260 702364 716205 728605 731124 732940 735905 759570 778558 787029 788544 794202 794240 794248 796862 796919 797170 797171 802631 808005 808228 819511 823767 824174 824725 826335 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (7.99%) |
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 530013 512138 523241 525507 534255 461031 469314 561529 561572 542285 545905 563656 547009 564191 577388 583096 695386 716205 651887 687430 563036 572303 591317 604412 586360 601134 607673 643380 597849 600799 794240 796919 797171 802631 808228 778558 794202 808005 728605 731124 796862 759570 604556 641115 701260 787029 788544 794248 391653 247381 397998 411330 453767 391980 294327 394737 411347 424084 466201 587896 591272 389257 824725 732940 496887 532019 527140 514902 579707 549826 584136 618622 797170 404483 451464 457420 536939 483628 483639 485697 453244 826335 735905 187268 391592 396780 426294 430134 424517 823767 819511 824174 474116 453072 453153 474851 472568 490402 511510 518855 500874 506931 523034 530270 531799 534258 521270 525508 509599 549250 549652 565732 559040 566363 577572 658470 673651 677892 702364 664972 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.38%) |
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 187268 247381 294327 389257 391592 391653 391980 394737 396780 397998 404483 411330 411347 424084 424517 426294 430134 451464 453072 453153 453244 453767 457420 461031 466201 469314 472568 474116 474851 483628 483639 485697 490402 496887 500874 506931 509599 511510 512138 514902 518855 521270 523034 523241 525507 525508 527140 530013 530270 531799 532019 534255 534258 536939 542285 545905 547009 549250 549652 549826 559040 561529 561572 563036 563656 564191 565732 566363 572303 577388 577572 579707 583096 584136 586360 587896 591272 591317 597849 600799 601134 604412 604556 607673 618622 641115 643380 651887 658470 664972 673651 677892 687430 695386 701260 702364 716205 728605 731124 732940 735905 759570 778558 787029 788544 794202 794240 794248 796862 796919 797170 797171 802631 808005 808228 819511 823767 824174 824725 826335 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пышку в душе"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"полная ван"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.61%) |
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.