Query Metrics
7
Database Queries
7
Different statements
183.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.70 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 3.34 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mature anus"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.16 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 485229 564706 544490 562147 608939 642022 392007 429890 402649 425977 429895 430374 397340 464413 496074 494233 525393 558176 541651 493573 591736 395818 433835 414157 423657 481878 485234 452108 523358 534567 496997 592440 622978 452161 405222 418522 437830 527888 597736 445436 448807 576723 406381 413901 502283 412925 431117 476123 448805 477744 522768 590362 410642 426399 497665 504738 504474 391386 523537 583913 599844 617137 636295 614858 444918 434309 647860 473391 523360 489424 531117 510898 526553 630596 466989 433074 532975 647948 622938 591354 605586 642016 469462 502043 527451 445617 444916 ] |
||||||||||||||||||||||||||||||
| 4 | 2.46 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 391386 392007 395818 397340 402649 405222 406381 410642 412925 413901 414157 418522 423657 425977 426399 429890 429895 430374 431117 433074 433835 434309 437830 444916 444918 445436 445617 448805 448807 452108 452161 464413 466989 469462 473391 476123 477744 481878 485229 485234 489424 493573 494233 496074 496997 497665 502043 502283 504474 504738 510898 522768 523358 523360 523537 525393 526553 527451 527888 531117 532975 534567 541651 544490 558176 562147 564706 576723 583913 590362 591354 591736 592440 597736 599844 605586 608939 614858 617137 622938 622978 630596 636295 642016 642022 647860 647948 ] |
||||||||||||||||||||||||||||||
| 5 | 156.94 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 391386 392007 395818 397340 402649 405222 406381 410642 412925 413901 414157 418522 423657 425977 426399 429890 429895 430374 431117 433074 433835 434309 437830 444916 444918 445436 445617 448805 448807 452108 452161 464413 466989 469462 473391 476123 477744 481878 485229 485234 489424 493573 494233 496074 496997 497665 502043 502283 504474 504738 510898 522768 523358 523360 523537 525393 526553 527451 527888 531117 532975 534567 541651 544490 558176 562147 564706 576723 583913 590362 591354 591736 592440 597736 599844 605586 608939 614858 617137 622938 622978 630596 636295 642016 642022 647860 647948 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mature анус"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mature анус"
]
|
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.