Query Metrics
7
Database Queries
7
Different statements
156.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.23 ms (82.98%) |
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 382474 382827 402404 408489 408787 412055 416320 418852 420674 435399 438539 438838 446170 447774 450671 457353 458439 458689 459466 459786 460354 461215 461250 461448 461460 461478 461575 462167 464523 464745 465841 465846 470303 470311 474062 476365 476388 478274 479496 479980 483242 483614 484822 486705 489566 489874 490597 490794 492663 492987 494411 495382 498079 499020 506215 509099 509438 510796 513690 513744 518058 524252 524526 524703 534170 538556 546019 547604 552159 552206 552235 552624 561695 566752 570366 572484 573848 584424 585090 587191 587856 598390 604023 620737 621872 652203 655058 655090 656044 656061 657093 657289 658407 658608 659670 673457 676527 694102 697322 705009 711050 743447 754715 754776 755046 768701 771736 772651 773826 774099 778374 778876 791018 792455 794060 799804 806789 807434 810438 811626 ] |
||||||||||||||||||||||||||||||
|
16.11 ms (10.27%) |
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 552624 584424 587191 416320 461478 461575 489566 510796 408787 657289 772651 754715 774099 461448 778876 476388 476365 446170 534170 509438 806789 461215 474062 479496 524252 489874 499020 509099 513690 483242 768701 561695 518058 524526 484822 486705 494411 552159 570366 573848 676527 697322 546019 811626 773826 778374 465841 479980 552206 807434 464523 478274 402404 461460 464745 382827 458689 459786 450671 513744 490597 438838 652203 620737 799804 458439 495382 566752 435399 470303 457353 438539 492663 604023 547604 658608 705009 711050 656044 598390 792455 771736 621872 585090 465846 791018 794060 810438 587856 420674 483614 490794 552235 447774 412055 418852 460354 461250 462167 408489 498079 492987 506215 524703 459466 470311 382474 538556 655090 656061 657093 659670 673457 655058 658407 572484 755046 754776 743447 694102 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.07%) |
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 382474 382827 402404 408489 408787 412055 416320 418852 420674 435399 438539 438838 446170 447774 450671 457353 458439 458689 459466 459786 460354 461215 461250 461448 461460 461478 461575 462167 464523 464745 465841 465846 470303 470311 474062 476365 476388 478274 479496 479980 483242 483614 484822 486705 489566 489874 490597 490794 492663 492987 494411 495382 498079 499020 506215 509099 509438 510796 513690 513744 518058 524252 524526 524703 534170 538556 546019 547604 552159 552206 552235 552624 561695 566752 570366 572484 573848 584424 585090 587191 587856 598390 604023 620737 621872 652203 655058 655090 656044 656061 657093 657289 658407 658608 659670 673457 676527 694102 697322 705009 711050 743447 754715 754776 755046 768701 771736 772651 773826 774099 778374 778876 791018 792455 794060 799804 806789 807434 810438 811626 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian beautiful girl"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.96%) |
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.