Query Metrics
7
Database Queries
7
Different statements
150.52 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.46 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"эма"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.38 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 736663 748968 620964 624487 704221 706497 715724 716298 786469 806879 463226 491170 529076 492399 512318 499121 531103 529940 524004 533186 556503 559686 577404 663261 677744 650187 592004 594019 606744 604423 807557 801958 810936 812800 458866 507275 487427 493105 482747 538267 536580 537933 493095 571833 564949 579948 565165 677831 648859 704528 646447 594422 632699 807407 748931 809468 476514 521483 533371 532741 533367 502273 554104 555509 543342 647322 640758 637009 760794 704222 528258 513072 535006 558194 563742 660439 674952 674953 674047 674959 676112 570076 642066 604067 632588 632001 632645 632646 532674 567771 639824 634543 641956 533014 657704 676634 630756 632595 634801 494059 509666 530382 674995 686843 666894 628336 628383 634218 577403 642774 630531 ] |
||||||||||||||||||||||||||||||
| 4 | 2.55 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 458866 463226 476514 482747 487427 491170 492399 493095 493105 494059 499121 502273 507275 509666 512318 513072 521483 524004 528258 529076 529940 530382 531103 532674 532741 533014 533186 533367 533371 535006 536580 537933 538267 543342 554104 555509 556503 558194 559686 563742 564949 565165 567771 570076 571833 577403 577404 579948 592004 594019 594422 604067 604423 606744 620964 624487 628336 628383 630531 630756 632001 632588 632595 632645 632646 632699 634218 634543 634801 637009 639824 640758 641956 642066 642774 646447 647322 648859 650187 657704 660439 663261 666894 674047 674952 674953 674959 674995 676112 676634 677744 677831 686843 704221 704222 704528 706497 715724 716298 736663 748931 748968 760794 786469 801958 806879 807407 807557 809468 810936 812800 ] |
||||||||||||||||||||||||||||||
| 5 | 125.24 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 458866 463226 476514 482747 487427 491170 492399 493095 493105 494059 499121 502273 507275 509666 512318 513072 521483 524004 528258 529076 529940 530382 531103 532674 532741 533014 533186 533367 533371 535006 536580 537933 538267 543342 554104 555509 556503 558194 559686 563742 564949 565165 567771 570076 571833 577403 577404 579948 592004 594019 594422 604067 604423 606744 620964 624487 628336 628383 630531 630756 632001 632588 632595 632645 632646 632699 634218 634543 634801 637009 639824 640758 641956 642066 642774 646447 647322 648859 650187 657704 660439 663261 666894 674047 674952 674953 674959 674995 676112 676634 677744 677831 686843 704221 704222 704528 706497 715724 716298 736663 748931 748968 760794 786469 801958 806879 807407 807557 809468 810936 812800 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"эм"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.22 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.