Query Metrics
7
Database Queries
7
Different statements
312.82 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.62 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ногтями"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.09 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 579425 582417 583052 583257 583581 542904 549517 552779 553079 562872 566755 567112 569054 576520 576611 577100 584809 684660 685617 653146 673845 687586 690846 659322 668360 669218 672423 674758 678175 686882 690859 547958 550091 551025 556121 557336 564856 566105 566691 569197 577980 581242 583262 584282 585787 587302 589703 592492 595158 599376 599974 602016 605003 606173 609689 609841 616909 618688 623715 624877 629421 631054 643317 587912 587928 589318 590020 594594 594933 595780 597722 598246 598625 602194 603967 604276 609580 609709 611330 612478 624886 626153 587866 596956 597161 597182 597430 599150 602578 602933 606199 615587 615689 615836 620083 623701 623962 624320 625860 628681 590344 592184 598882 599203 601339 602576 605826 608427 613354 615838 622594 623610 627701 633937 641672 603420 604994 611950 612346 615182 ] |
||||||||||||||||||||||||||||||
| 4 | 2.75 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 542904 547958 549517 550091 551025 552779 553079 556121 557336 562872 564856 566105 566691 566755 567112 569054 569197 576520 576611 577100 577980 579425 581242 582417 583052 583257 583262 583581 584282 584809 585787 587302 587866 587912 587928 589318 589703 590020 590344 592184 592492 594594 594933 595158 595780 596956 597161 597182 597430 597722 598246 598625 598882 599150 599203 599376 599974 601339 602016 602194 602576 602578 602933 603420 603967 604276 604994 605003 605826 606173 606199 608427 609580 609689 609709 609841 611330 611950 612346 612478 613354 615182 615587 615689 615836 615838 616909 618688 620083 622594 623610 623701 623715 623962 624320 624877 624886 625860 626153 627701 628681 629421 631054 633937 641672 643317 653146 659322 668360 669218 672423 673845 674758 678175 684660 685617 686882 687586 690846 690859 ] |
||||||||||||||||||||||||||||||
| 5 | 289.16 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 542904 547958 549517 550091 551025 552779 553079 556121 557336 562872 564856 566105 566691 566755 567112 569054 569197 576520 576611 577100 577980 579425 581242 582417 583052 583257 583262 583581 584282 584809 585787 587302 587866 587912 587928 589318 589703 590020 590344 592184 592492 594594 594933 595158 595780 596956 597161 597182 597430 597722 598246 598625 598882 599150 599203 599376 599974 601339 602016 602194 602576 602578 602933 603420 603967 604276 604994 605003 605826 606173 606199 608427 609580 609689 609709 609841 611330 611950 612346 612478 613354 615182 615587 615689 615836 615838 616909 618688 620083 622594 623610 623701 623715 623962 624320 624877 624886 625860 626153 627701 628681 629421 631054 633937 641672 643317 653146 659322 668360 669218 672423 673845 674758 678175 684660 685617 686882 687586 690846 690859 ] |
||||||||||||||||||||||||||||||
| 6 | 2.24 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ногт"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.38 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.