Query Metrics
7
Database Queries
7
Different statements
119.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.95 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade teen tight"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.74 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 521241 525281 528938 541033 510522 489361 395375 434557 436139 427601 476887 516693 508168 560442 695178 587011 428047 473529 459615 416009 428570 479763 520129 498260 496451 502191 490173 575154 459504 499628 457974 522000 524178 452279 496069 574696 655255 621252 459360 464802 471316 526241 603001 626227 731226 446657 448221 483094 495163 515866 490071 508569 618381 550531 485150 485899 451372 454923 465946 492170 563553 806580 418605 549860 433745 408994 505611 597902 508974 527218 443491 476223 579353 454984 523814 562311 434702 553031 548304 396087 515201 415134 626881 561304 573615 598592 532255 ] |
||||||||||||||||||||||||||||||
| 4 | 2.69 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 395375 396087 408994 415134 416009 418605 427601 428047 428570 433745 434557 434702 436139 443491 446657 448221 451372 452279 454923 454984 457974 459360 459504 459615 464802 465946 471316 473529 476223 476887 479763 483094 485150 485899 489361 490071 490173 492170 495163 496069 496451 498260 499628 502191 505611 508168 508569 508974 510522 515201 515866 516693 520129 521241 522000 523814 524178 525281 526241 527218 528938 532255 541033 548304 549860 550531 553031 560442 561304 562311 563553 573615 574696 575154 579353 587011 597902 598592 603001 618381 621252 626227 626881 655255 695178 731226 806580 ] |
||||||||||||||||||||||||||||||
| 5 | 94.14 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 395375 396087 408994 415134 416009 418605 427601 428047 428570 433745 434557 434702 436139 443491 446657 448221 451372 452279 454923 454984 457974 459360 459504 459615 464802 465946 471316 473529 476223 476887 479763 483094 485150 485899 489361 490071 490173 492170 495163 496069 496451 498260 499628 502191 505611 508168 508569 508974 510522 515201 515866 516693 520129 521241 522000 523814 524178 525281 526241 527218 528938 532255 541033 548304 549860 550531 553031 560442 561304 562311 563553 573615 574696 575154 579353 587011 597902 598592 603001 618381 621252 626227 626881 655255 695178 731226 806580 ] |
||||||||||||||||||||||||||||||
| 6 | 1.70 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск teen tight"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск teen tight"
]
|
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.