Query Metrics
7
Database Queries
7
Different statements
190.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.73 ms (81.91%) |
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 317820 357782 397046 401243 410848 418213 427149 428882 436438 438446 438501 439240 439264 439268 439587 441933 444331 445864 445989 448109 453982 456624 460038 461215 465878 469685 469892 471069 472258 472624 473424 473951 474101 474304 475731 478734 479465 479582 482498 482635 487833 491631 492355 496704 499198 506755 512714 520241 522320 523463 523599 526798 527805 529032 532608 534106 536376 539438 543838 545304 546600 547183 548556 548594 550451 553248 553315 554408 554707 554986 556096 557467 557492 557878 558466 558630 559570 560508 562467 564603 566236 567272 569480 570294 571141 571940 574040 574942 577345 577926 579426 583131 585344 588186 590956 593230 596255 600197 601813 602189 603385 603399 620820 627822 629673 634345 650295 653478 654783 661000 669322 676649 676687 687293 687306 726283 739261 742923 757998 814280 ] |
||||||||||||||||||||||||||||||
|
23.57 ms (12.40%) |
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 469892 590956 427149 441933 448109 687306 585344 556096 574942 653478 571141 627822 487833 566236 539438 571940 445989 439587 473424 473951 410848 472258 482498 499198 523599 527805 550451 558630 569480 574040 669322 546600 554408 557467 583131 588186 593230 629673 438446 506755 676649 418213 634345 577345 444331 461215 654783 557878 742923 428882 523463 601813 534106 474101 553315 553248 726283 471069 439240 532608 564603 650295 496704 397046 557492 676687 600197 469685 475731 560508 482635 520241 536376 474304 456624 492355 491631 596255 603385 577926 687293 567272 603399 548594 554986 317820 438501 478734 526798 479465 548556 579426 543838 547183 559570 562467 570294 545304 602189 620820 357782 439268 479582 439264 436438 453982 460038 512714 522320 814280 554707 661000 739261 757998 472624 445864 465878 529032 558466 401243 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.77%) |
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 317820 357782 397046 401243 410848 418213 427149 428882 436438 438446 438501 439240 439264 439268 439587 441933 444331 445864 445989 448109 453982 456624 460038 461215 465878 469685 469892 471069 472258 472624 473424 473951 474101 474304 475731 478734 479465 479582 482498 482635 487833 491631 492355 496704 499198 506755 512714 520241 522320 523463 523599 526798 527805 529032 532608 534106 536376 539438 543838 545304 546600 547183 548556 548594 550451 553248 553315 554408 554707 554986 556096 557467 557492 557878 558466 558630 559570 560508 562467 564603 566236 567272 569480 570294 571141 571940 574040 574942 577345 577926 579426 583131 585344 588186 590956 593230 596255 600197 601813 602189 603385 603399 620820 627822 629673 634345 650295 653478 654783 661000 669322 676649 676687 687293 687306 726283 739261 742923 757998 814280 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"снимаем трусики с девушек"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"снима трусик нижн бел девушк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.79%) |
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.