Query Metrics
7
Database Queries
7
Different statements
173.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.02 ms (82.24%) |
1 |
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 388281 388668 416303 420336 420406 423266 424401 425332 428404 439823 444158 452152 460879 463096 465060 467605 470839 472928 480461 484069 484092 484125 490864 491871 492002 494768 494770 498022 501313 501506 503441 506364 506659 515226 515290 515833 516771 519061 519727 521357 521637 522858 524508 524751 524773 527902 530650 534021 541884 543195 545517 545695 548538 548548 548550 548574 552264 553096 553717 553720 558127 559095 560941 561296 561970 563991 565253 568573 577323 583677 586468 593348 593487 596586 596839 596856 596880 596933 596960 597230 599299 599885 600071 600078 600115 600253 600350 610390 614441 615742 620280 620992 623413 624178 625171 627808 628315 634145 637026 637031 637074 637093 639798 642875 646851 668137 669577 675537 677963 680122 680181 680206 686710 687551 688332 688340 699610 717860 749693 750538 ] |
||||||||||||||||||||||||||||||
|
19.47 ms (11.20%) |
1 |
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 688340 717860 668137 680122 686710 687551 552264 586468 597230 599885 624178 628315 596960 600115 600253 637026 610390 749693 625171 465060 388281 420336 439823 452152 472928 423266 470839 490864 506364 515290 484092 492002 524751 503441 506659 515833 558127 623413 425332 428404 463096 501506 516771 522858 519061 530650 484125 543195 548550 568573 559095 548548 553720 563991 669577 677963 680206 688332 545517 548574 553096 560941 565253 593348 615742 634145 599299 600350 614441 637031 600078 642875 750538 416303 480461 444158 521637 521357 494768 515226 420406 524773 501313 460879 541884 561296 583677 675537 680181 699610 596933 593487 596880 424401 467605 596586 637074 484069 498022 494770 553717 548538 561970 577323 637093 600071 627808 388668 491871 519727 620992 596839 527902 534021 524508 646851 545695 596856 620280 639798 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (1.90%) |
1 |
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 388281 388668 416303 420336 420406 423266 424401 425332 428404 439823 444158 452152 460879 463096 465060 467605 470839 472928 480461 484069 484092 484125 490864 491871 492002 494768 494770 498022 501313 501506 503441 506364 506659 515226 515290 515833 516771 519061 519727 521357 521637 522858 524508 524751 524773 527902 530650 534021 541884 543195 545517 545695 548538 548548 548550 548574 552264 553096 553717 553720 558127 559095 560941 561296 561970 563991 565253 568573 577323 583677 586468 593348 593487 596586 596839 596856 596880 596933 596960 597230 599299 599885 600071 600078 600115 600253 600350 610390 614441 615742 620280 620992 623413 624178 625171 627808 628315 634145 637026 637031 637074 637093 639798 642875 646851 668137 669577 675537 677963 680122 680181 680206 686710 687551 688332 688340 699610 717860 749693 750538 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen uniform"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen униформ"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen униформ"
]
|
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.