Query Metrics
7
Database Queries
7
Different statements
124.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.74 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.12 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick beach"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.11 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 475849 633209 472358 479787 455873 497187 505421 453069 578494 663992 819440 818815 565378 559027 593245 396980 459264 552326 485353 435277 447883 825596 512890 444412 456138 463456 463705 516250 486105 515179 529039 553957 559014 553127 559736 636434 445778 478586 538653 542525 448375 457289 476603 455016 497581 541316 605396 509802 456857 458442 454669 489023 500901 515167 441546 441631 511562 458991 568505 444972 458437 479637 510270 418018 578378 533631 537268 515153 500482 457611 482256 539248 526168 598749 548849 441640 595877 435479 559069 565095 511028 566502 653463 541712 455795 541877 541638 601944 580969 ] |
||||||||||||||||||||||||||||||
| 4 | 3.23 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 396980 418018 435277 435479 441546 441631 441640 444412 444972 445778 447883 448375 453069 454669 455016 455795 455873 456138 456857 457289 457611 458437 458442 458991 459264 463456 463705 472358 475849 476603 478586 479637 479787 482256 485353 486105 489023 497187 497581 500482 500901 505421 509802 510270 511028 511562 512890 515153 515167 515179 516250 526168 529039 533631 537268 538653 539248 541316 541638 541712 541877 542525 548849 552326 553127 553957 559014 559027 559069 559736 565095 565378 566502 568505 578378 578494 580969 593245 595877 598749 601944 605396 633209 636434 653463 663992 818815 819440 825596 ] |
||||||||||||||||||||||||||||||
| 5 | 97.33 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 396980 418018 435277 435479 441546 441631 441640 444412 444972 445778 447883 448375 453069 454669 455016 455795 455873 456138 456857 457289 457611 458437 458442 458991 459264 463456 463705 472358 475849 476603 478586 479637 479787 482256 485353 486105 489023 497187 497581 500482 500901 505421 509802 510270 511028 511562 512890 515153 515167 515179 516250 526168 529039 533631 537268 538653 539248 541316 541638 541712 541877 542525 548849 552326 553127 553957 559014 559027 559069 559736 565095 565378 566502 568505 578378 578494 580969 593245 595877 598749 601944 605396 633209 636434 653463 663992 818815 819440 825596 ] |
||||||||||||||||||||||||||||||
| 6 | 1.90 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член пляж природ"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.81 ms |
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.