Query Metrics
7
Database Queries
7
Different statements
173.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.51 ms (86.03%) |
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 4274 10035 14599 16679 31627 53698 129791 239542 241603 251476 263299 309991 318315 318318 381828 385024 385742 386835 387085 387207 389757 390378 396168 396261 396662 396677 397329 401124 401966 403418 403539 417362 420460 421249 421696 427221 428543 428631 431410 432081 432595 446375 447846 453790 456398 456597 456676 457528 457776 463114 474442 482566 490837 493488 497524 497806 509151 509161 510586 519447 519683 520727 522515 523634 525749 526083 533997 536894 540461 547954 558659 559598 563399 568327 571441 576074 583976 591736 597831 599271 599586 603460 605500 627103 629381 642260 657246 663912 665122 677352 680102 693898 695338 705741 720515 724536 725826 726157 726788 728114 731053 737445 745683 750271 758430 762226 775355 780876 782252 788772 788912 789544 795529 797736 804114 804249 805309 807725 809328 810031 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (8.45%) |
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 726788 725826 750271 788772 804249 805309 810031 239542 386835 4274 403418 788912 387085 568327 599586 597831 605500 396168 309991 381828 16679 396261 417362 428543 482566 463114 453790 456597 457776 519683 533997 510586 526083 540461 490837 680102 663912 677352 559598 603460 591736 627103 807725 737445 387207 432595 31627 397329 318315 509161 522515 509151 497524 519447 241603 263299 389757 390378 421249 421696 427221 493488 456398 456676 447846 536894 571441 629381 797736 396662 385742 523634 385024 251476 129791 318318 53698 14599 396677 403539 420460 474442 446375 558659 547954 665122 657246 693898 705741 695338 720515 642260 599271 775355 789544 795529 809328 780876 758430 724536 745683 728114 731053 762226 726157 782252 804114 401124 401966 457528 10035 525749 497806 428631 431410 520727 583976 563399 576074 432081 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.41%) |
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 4274 10035 14599 16679 31627 53698 129791 239542 241603 251476 263299 309991 318315 318318 381828 385024 385742 386835 387085 387207 389757 390378 396168 396261 396662 396677 397329 401124 401966 403418 403539 417362 420460 421249 421696 427221 428543 428631 431410 432081 432595 446375 447846 453790 456398 456597 456676 457528 457776 463114 474442 482566 490837 493488 497524 497806 509151 509161 510586 519447 519683 520727 522515 523634 525749 526083 533997 536894 540461 547954 558659 559598 563399 568327 571441 576074 583976 591736 597831 599271 599586 603460 605500 627103 629381 642260 657246 663912 665122 677352 680102 693898 695338 705741 720515 724536 725826 726157 726788 728114 731053 737445 745683 750271 758430 762226 775355 780876 782252 788772 788912 789544 795529 797736 804114 804249 805309 807725 809328 810031 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man ass"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин жоп"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.