Query Metrics
7
Database Queries
7
Different statements
170.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.81 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal masturbation"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.92 ms |
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 513604 620223 466404 586917 516478 498492 422172 419455 557969 647986 676638 806534 760209 639722 473511 542247 799360 597216 639751 477873 536400 599988 647948 675010 639258 639719 642006 642037 472956 585477 546958 621976 515363 523924 636315 534994 591706 493249 522231 665728 424265 648220 585007 510109 814049 717236 576721 582282 529792 641978 506269 463777 675897 589968 446373 530479 616205 544788 652316 466063 591692 503044 518219 665328 496554 400497 581383 522604 600014 604865 454568 483569 522913 624742 468835 452136 464445 508565 430437 418135 588624 516686 541721 591135 ] |
||||||||||||||||||||||||||||||
| 4 | 3.79 ms |
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 400497 418135 419455 422172 424265 430437 446373 452136 454568 463777 464445 466063 466404 468835 472956 473511 477873 483569 493249 496554 498492 503044 506269 508565 510109 513604 515363 516478 516686 518219 522231 522604 522913 523924 529792 530479 534994 536400 541721 542247 544788 546958 557969 576721 581383 582282 585007 585477 586917 588624 589968 591135 591692 591706 597216 599988 600014 604865 616205 620223 621976 624742 636315 639258 639719 639722 639751 641978 642006 642037 647948 647986 648220 652316 665328 665728 675010 675897 676638 717236 760209 799360 806534 814049 ] |
||||||||||||||||||||||||||||||
| 5 | 141.63 ms |
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 400497 418135 419455 422172 424265 430437 446373 452136 454568 463777 464445 466063 466404 468835 472956 473511 477873 483569 493249 496554 498492 503044 506269 508565 510109 513604 515363 516478 516686 518219 522231 522604 522913 523924 529792 530479 534994 536400 541721 542247 544788 546958 557969 576721 581383 582282 585007 585477 586917 588624 589968 591135 591692 591706 597216 599988 600014 604865 616205 620223 621976 624742 636315 639258 639719 639722 639751 641978 642006 642037 647948 647986 648220 652316 665328 665728 675010 675897 676638 717236 760209 799360 806534 814049 ] |
||||||||||||||||||||||||||||||
| 6 | 1.71 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал мастурбац"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.70 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал мастурбац"
]
|
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.