Query Metrics
7
Database Queries
7
Different statements
114.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.87 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.00 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny mature blonde"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.45 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 408157 443802 443700 413819 502866 587185 282010 462698 452061 496100 417485 484161 509024 496872 565165 573729 702621 400148 413185 466971 384413 400181 424470 491266 499365 418934 463768 504841 558003 489950 492472 525116 533957 400254 433747 466678 501465 592408 407895 397369 405145 521159 413000 430175 448672 450849 502310 496360 577410 607293 522902 448644 430828 431352 527967 482492 513050 519561 454709 477686 487514 434192 492106 497404 518960 555953 601856 603364 470685 403939 487717 520445 487703 576717 559392 543772 607374 624084 518237 520803 542199 ] |
||||||||||||||||||||||||||||||
| 4 | 2.78 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 282010 384413 397369 400148 400181 400254 403939 405145 407895 408157 413000 413185 413819 417485 418934 424470 430175 430828 431352 433747 434192 443700 443802 448644 448672 450849 452061 454709 462698 463768 466678 466971 470685 477686 482492 484161 487514 487703 487717 489950 491266 492106 492472 496100 496360 496872 497404 499365 501465 502310 502866 504841 509024 513050 518237 518960 519561 520445 520803 521159 522902 525116 527967 533957 542199 543772 555953 558003 559392 565165 573729 576717 577410 587185 592408 601856 603364 607293 607374 624084 702621 ] |
||||||||||||||||||||||||||||||
| 5 | 89.29 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 282010 384413 397369 400148 400181 400254 403939 405145 407895 408157 413000 413185 413819 417485 418934 424470 430175 430828 431352 433747 434192 443700 443802 448644 448672 450849 452061 454709 462698 463768 466678 466971 470685 477686 482492 484161 487514 487703 487717 489950 491266 492106 492472 496100 496360 496872 497404 499365 501465 502310 502866 504841 509024 513050 518237 518960 519561 520445 520803 521159 522902 525116 527967 533957 542199 543772 555953 558003 559392 565165 573729 576717 577410 587185 592408 601856 603364 607293 607374 624084 702621 ] |
||||||||||||||||||||||||||||||
| 6 | 1.55 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые mature беловолосая"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.46 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.