Query Metrics
7
Database Queries
7
Different statements
139.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.04 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil teen solo"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.79 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 477761 415961 439359 456239 498294 488752 498319 514248 516024 436186 435793 428944 416626 416694 433601 435722 429608 430262 416681 448090 456131 466637 447608 520419 502767 532778 506688 518191 545436 575178 568301 624191 640270 625780 432268 443086 468237 414081 416539 465148 416680 439010 416614 495470 493398 506105 511127 515440 497667 452567 613515 415966 416677 416751 431540 416529 449086 452798 462845 752700 471118 432288 418144 471115 476649 541275 510532 416635 498226 580111 585079 516602 545376 595847 585951 602183 602614 615918 423783 531351 397568 428742 595434 446745 569656 495568 436074 ] |
||||||||||||||||||||||||||||||
| 4 | 3.60 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 397568 414081 415961 415966 416529 416539 416614 416626 416635 416677 416680 416681 416694 416751 418144 423783 428742 428944 429608 430262 431540 432268 432288 433601 435722 435793 436074 436186 439010 439359 443086 446745 447608 448090 449086 452567 452798 456131 456239 462845 465148 466637 468237 471115 471118 476649 477761 488752 493398 495470 495568 497667 498226 498294 498319 502767 506105 506688 510532 511127 514248 515440 516024 516602 518191 520419 531351 532778 541275 545376 545436 568301 569656 575178 580111 585079 585951 595434 595847 602183 602614 613515 615918 624191 625780 640270 752700 ] |
||||||||||||||||||||||||||||||
| 5 | 112.65 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 397568 414081 415961 415966 416529 416539 416614 416626 416635 416677 416680 416681 416694 416751 418144 423783 428742 428944 429608 430262 431540 432268 432288 433601 435722 435793 436074 436186 439010 439359 443086 446745 447608 448090 449086 452567 452798 456131 456239 462845 465148 466637 468237 471115 471118 476649 477761 488752 493398 495470 495568 497667 498226 498294 498319 502767 506105 506688 510532 511127 514248 515440 516024 516602 518191 520419 531351 532778 541275 545376 545436 568301 569656 575178 580111 585079 585951 595434 595847 602183 602614 613515 615918 624191 625780 640270 752700 ] |
||||||||||||||||||||||||||||||
| 6 | 1.66 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл teen соло"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.55 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"масл teen соло"
]
|
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.