Query Metrics
7
Database Queries
7
Different statements
144.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.04 ms (82.89%) |
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 81869 89021 131474 192551 391102 396029 400470 401047 410008 416873 419281 420109 420580 428623 432370 432392 432393 432481 432497 432886 433366 433452 433729 433953 434093 434768 437779 438023 441231 441334 442802 443173 443852 446086 447797 448198 449397 453022 454020 455383 455448 456447 456916 458295 458821 459574 462954 465002 470706 473206 473629 478296 484490 490732 493296 494195 499266 499414 501348 502220 503483 505261 505705 512702 513579 515317 517174 517377 521348 521646 527675 530210 530244 532301 538060 545745 546580 548555 552366 553260 554046 556726 557405 563670 564068 567701 568961 574014 576556 577413 582934 586741 591080 596441 601435 613882 699189 744780 754145 766931 768208 777232 778606 779827 780230 782486 787971 788462 789085 792351 795127 795361 796693 801505 802092 802093 806263 813045 813444 ] |
||||||||||||||||||||||||||||||
|
13.88 ms (9.58%) |
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 778606 795361 796693 769187 576556 777232 787971 574014 556726 433729 499266 813045 442802 441334 448198 449397 458295 470706 478296 548555 567701 553260 401047 416873 432497 458821 456447 447797 459574 473206 517174 501348 502220 437779 517377 596441 515317 432481 432393 699189 462954 419281 131474 438023 802093 443173 538060 554046 813444 768208 433366 802092 766931 801505 582934 391102 789085 806263 782486 192551 513579 410008 532301 754145 795127 432370 432886 545745 744780 779827 396029 456916 473629 613882 788462 420109 792351 432392 441231 490732 446086 453022 552366 546580 557405 563670 577413 586741 591080 433452 420580 434093 530244 484490 521646 527675 512702 521348 400470 499414 81869 530210 564068 505261 465002 455448 568961 455383 443852 433953 89021 503483 780230 434768 428623 494195 601435 454020 493296 505705 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (2.16%) |
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 81869 89021 131474 192551 391102 396029 400470 401047 410008 416873 419281 420109 420580 428623 432370 432392 432393 432481 432497 432886 433366 433452 433729 433953 434093 434768 437779 438023 441231 441334 442802 443173 443852 446086 447797 448198 449397 453022 454020 455383 455448 456447 456916 458295 458821 459574 462954 465002 470706 473206 473629 478296 484490 490732 493296 494195 499266 499414 501348 502220 503483 505261 505705 512702 513579 515317 517174 517377 521348 521646 527675 530210 530244 532301 538060 545745 546580 548555 552366 553260 554046 556726 557405 563670 564068 567701 568961 574014 576556 577413 582934 586741 591080 596441 601435 613882 699189 744780 754145 766931 768208 777232 778606 779827 780230 782486 787971 788462 789085 792351 795127 795361 796693 801505 802092 802093 806263 813045 813444 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"парень дрочит частное…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"парен дрочк любительск"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.