Query Metrics
7
Database Queries
7
Different statements
392.54 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.03 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 210.28 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"machine dildo anal"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.58 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 432296 652223 448898 513221 785880 517710 450357 413406 429602 532940 500789 651062 576125 806384 788776 765668 806413 438464 433002 540348 550672 413376 434371 420116 398064 458761 523885 532739 413398 434286 416192 700685 606549 783486 640948 405683 418135 429044 541839 439171 434337 480475 744939 430355 451064 475414 401784 439931 458770 549514 430374 443103 452813 530387 534381 434374 434364 486763 511376 595165 599852 468012 410683 428773 494006 500912 617418 716394 499789 542904 535084 509800 480351 626617 576219 428959 625660 466443 467946 421366 542549 444924 559111 514404 494492 ] |
||||||||||||||||||||||||||||||
| 4 | 3.26 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 398064 401784 405683 410683 413376 413398 413406 416192 418135 420116 421366 428773 428959 429044 429602 430355 430374 432296 433002 434286 434337 434364 434371 434374 438464 439171 439931 443103 444924 448898 450357 451064 452813 458761 458770 466443 467946 468012 475414 480351 480475 486763 494006 494492 499789 500789 500912 509800 511376 513221 514404 517710 523885 530387 532739 532940 534381 535084 540348 541839 542549 542904 549514 550672 559111 576125 576219 595165 599852 606549 617418 625660 626617 640948 651062 652223 700685 716394 744939 765668 783486 785880 788776 806384 806413 ] |
||||||||||||||||||||||||||||||
| 5 | 158.91 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 398064 401784 405683 410683 413376 413398 413406 416192 418135 420116 421366 428773 428959 429044 429602 430355 430374 432296 433002 434286 434337 434364 434371 434374 438464 439171 439931 443103 444924 448898 450357 451064 452813 458761 458770 466443 467946 468012 475414 480351 480475 486763 494006 494492 499789 500789 500912 509800 511376 513221 514404 517710 523885 530387 532739 532940 534381 535084 540348 541839 542549 542904 549514 550672 559111 576125 576219 595165 599852 606549 617418 625660 626617 640948 651062 652223 700685 716394 744939 765668 783486 785880 788776 806384 806413 ] |
||||||||||||||||||||||||||||||
| 6 | 1.94 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"machine дилд анал"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.54 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"machine дилд анал"
]
|
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.