Query Metrics
7
Database Queries
7
Different statements
666.58 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.62 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.77 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кримпай жена"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.63 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 796199 613429 709505 793822 716013 639164 675322 673177 526816 508696 557833 562819 569580 577446 653120 616519 620406 600518 591822 622529 761302 756629 635391 584365 707169 629821 612242 605598 481755 496479 622886 488385 488475 584843 559460 554960 721233 556075 592066 615300 730112 773369 737557 738566 793820 761596 508210 524824 504048 510878 507442 562492 660346 555194 556669 637313 595378 602511 595224 612301 505291 680459 609042 715407 675613 677258 759008 578796 585326 786369 528124 579576 575583 802150 791195 723622 650669 716045 781052 766263 813534 740849 629526 794396 580624 662486 518184 539349 586010 606858 630156 488510 528505 558342 684511 546865 546890 584504 592907 595047 633286 635009 630718 607996 710687 556229 568792 643751 566585 540396 530193 571149 556372 563792 591884 660030 630670 489251 517682 715012 ] |
||||||||||||||||||||||||||||||
| 4 | 207.21 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 481755 488385 488475 488510 489251 496479 504048 505291 507442 508210 508696 510878 517682 518184 524824 526816 528124 528505 530193 539349 540396 546865 546890 554960 555194 556075 556229 556372 556669 557833 558342 559460 562492 562819 563792 566585 568792 569580 571149 575583 577446 578796 579576 580624 584365 584504 584843 585326 586010 591822 591884 592066 592907 595047 595224 595378 600518 602511 605598 606858 607996 609042 612242 612301 613429 615300 616519 620406 622529 622886 629526 629821 630156 630670 630718 633286 635009 635391 637313 639164 643751 650669 653120 660030 660346 662486 673177 675322 675613 677258 680459 684511 707169 709505 710687 715012 715407 716013 716045 721233 723622 730112 737557 738566 740849 756629 759008 761302 761596 766263 773369 781052 786369 791195 793820 794396 796199 802150 813534 ] |
||||||||||||||||||||||||||||||
| 5 | 225.64 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 481755 488385 488475 488510 489251 496479 504048 505291 507442 508210 508696 510878 517682 518184 524824 526816 528124 528505 530193 539349 540396 546865 546890 554960 555194 556075 556229 556372 556669 557833 558342 559460 562492 562819 563792 566585 568792 569580 571149 575583 577446 578796 579576 580624 584365 584504 584843 585326 586010 591822 591884 592066 592907 595047 595224 595378 600518 602511 605598 606858 607996 609042 612242 612301 613429 615300 616519 620406 622529 622886 629526 629821 630156 630670 630718 633286 635009 635391 637313 639164 643751 650669 653120 660030 660346 662486 673177 675322 675613 677258 680459 684511 707169 709505 710687 715012 715407 716013 716045 721233 723622 730112 737557 738566 740849 756629 759008 761302 761596 766263 773369 781052 786369 791195 793820 794396 796199 802150 813534 ] |
||||||||||||||||||||||||||||||
| 6 | 215.98 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кремпа сперм жен"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.73 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кремпа сперм жен"
]
|
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.