Query Metrics
7
Database Queries
7
Different statements
165.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.63 ms (82.40%) |
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 11582 282218 330046 388746 395824 398464 401261 405468 418845 421204 423424 424304 430228 432869 433231 433295 433334 433498 434044 434046 434163 434212 435341 438001 447466 447692 447785 448801 452418 454228 456525 457041 457590 461337 462280 465070 466554 466959 467839 469443 470449 470987 474527 474549 474550 474557 474826 477895 478074 478828 480752 481591 483005 488897 489831 490035 490044 492338 502274 502306 502326 502505 505041 507686 510217 511422 513828 517687 520540 520711 523803 525747 527452 527454 531510 534823 540239 541370 541725 550325 552058 557182 562337 568506 568508 569549 590695 590879 595944 596147 596556 604436 606587 612472 615812 620130 621482 630542 636545 645241 650421 664157 669695 674118 674749 696598 699621 710943 716394 719001 720111 726332 734506 764490 788132 805020 809440 811220 815600 817865 ] |
||||||||||||||||||||||||||||||
|
18.71 ms (11.29%) |
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 474527 664157 726332 430228 817865 447692 719001 606587 435341 418845 395824 710943 490044 590695 447785 720111 421204 520711 523803 502505 511422 527452 474549 525747 457590 478828 11582 809440 478074 488897 636545 454228 481591 699621 569549 734506 630542 764490 401261 282218 434163 507686 811220 398464 434044 510217 461337 590879 696598 456525 615812 388746 405468 674118 531510 492338 447466 466554 433498 452418 462280 448801 470449 470987 424304 650421 505041 645241 434046 502274 552058 621482 474557 612472 805020 477895 483005 541725 562337 457041 434212 490035 502306 517687 595944 489831 467839 540239 568506 788132 604436 674749 502326 716394 550325 433231 596556 620130 465070 541370 557182 433334 474826 438001 596147 423424 474550 520540 815600 513828 480752 433295 669695 330046 568508 469443 466959 527454 534823 432869 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.72%) |
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 11582 282218 330046 388746 395824 398464 401261 405468 418845 421204 423424 424304 430228 432869 433231 433295 433334 433498 434044 434046 434163 434212 435341 438001 447466 447692 447785 448801 452418 454228 456525 457041 457590 461337 462280 465070 466554 466959 467839 469443 470449 470987 474527 474549 474550 474557 474826 477895 478074 478828 480752 481591 483005 488897 489831 490035 490044 492338 502274 502306 502326 502505 505041 507686 510217 511422 513828 517687 520540 520711 523803 525747 527452 527454 531510 534823 540239 541370 541725 550325 552058 557182 562337 568506 568508 569549 590695 590879 595944 596147 596556 604436 606587 612472 615812 620130 621482 630542 636545 645241 650421 664157 669695 674118 674749 696598 699621 710943 716394 719001 720111 726332 734506 764490 788132 805020 809440 811220 815600 817865 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation ffm"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.99%) |
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.