Query Metrics
7
Database Queries
7
Different statements
644.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 210.84 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.89 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teen dp"
]
|
||||||||||||||||||||||||||||||
| 3 | 26.82 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 497613 500312 566991 537210 558601 634818 634208 406308 418399 434000 443103 483544 461056 447926 535505 537903 537919 534995 540518 464168 550099 561980 566502 583936 541856 581349 543471 674927 676087 679016 649556 678127 649578 666883 586693 631965 590460 597252 600026 590542 628406 599912 622402 623198 634778 701010 428301 421271 461569 516350 505048 487713 427447 820759 481142 484457 446505 531255 534842 536638 527198 537660 539232 565267 678143 687158 647993 666878 672710 592034 593868 597204 634482 599969 615718 601624 601595 633775 432787 501382 465606 534021 558130 543858 544840 570704 647932 646427 677307 675009 617411 632978 403909 434712 537236 518473 530382 531123 558134 565276 650155 634198 588265 594231 540330 530369 598105 553280 541866 ] |
||||||||||||||||||||||||||||||
| 4 | 2.76 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 403909 406308 418399 421271 427447 428301 432787 434000 434712 443103 446505 447926 461056 461569 464168 465606 481142 483544 484457 487713 497613 500312 501382 505048 516350 518473 527198 530369 530382 531123 531255 534021 534842 534995 535505 536638 537210 537236 537660 537903 537919 539232 540330 540518 541856 541866 543471 543858 544840 550099 553280 558130 558134 558601 561980 565267 565276 566502 566991 570704 581349 583936 586693 588265 590460 590542 592034 593868 594231 597204 597252 598105 599912 599969 600026 601595 601624 615718 617411 622402 623198 628406 631965 632978 633775 634198 634208 634482 634778 634818 646427 647932 647993 649556 649578 650155 666878 666883 672710 674927 675009 676087 677307 678127 678143 679016 687158 701010 820759 ] |
||||||||||||||||||||||||||||||
| 5 | 399.73 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 403909 406308 418399 421271 427447 428301 432787 434000 434712 443103 446505 447926 461056 461569 464168 465606 481142 483544 484457 487713 497613 500312 501382 505048 516350 518473 527198 530369 530382 531123 531255 534021 534842 534995 535505 536638 537210 537236 537660 537903 537919 539232 540330 540518 541856 541866 543471 543858 544840 550099 553280 558130 558134 558601 561980 565267 565276 566502 566991 570704 581349 583936 586693 588265 590460 590542 592034 593868 594231 597204 597252 598105 599912 599969 600026 601595 601624 615718 617411 622402 623198 628406 631965 632978 633775 634198 634208 634482 634778 634818 646427 647932 647993 649556 649578 650155 666878 666883 672710 674927 675009 676087 677307 678127 678143 679016 687158 701010 820759 ] |
||||||||||||||||||||||||||||||
| 6 | 1.62 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teen dp"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.30 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teen dp"
]
|
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.