Query Metrics
7
Database Queries
7
Different statements
195.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.26 ms (87.50%) |
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 397535 414364 424904 427937 453825 469373 472431 474837 475799 478771 480293 480398 486470 495126 500740 500971 514594 518473 523418 526891 528761 530697 531123 531233 531248 532166 532744 532950 532965 532974 533044 533363 533521 533854 533931 534216 534999 536178 536291 536542 536550 536620 536744 537210 537212 537236 537888 537891 539203 540348 540573 541853 542877 544854 545372 545488 545611 553272 588265 599835 599865 599940 600021 600257 600269 605344 608035 614737 617427 628380 628383 630234 630295 630552 630857 630869 630902 632562 632593 632653 633776 634134 634140 634159 634169 634218 634780 636272 639334 641638 644278 650316 651674 666868 666880 666894 677296 677777 677784 678095 678097 678522 680176 680186 680195 680197 696606 703039 710425 717798 724230 724243 727751 729881 733866 740584 747281 748354 775056 818439 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (7.72%) |
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 634159 634169 641638 630857 632653 633776 636272 600269 605344 608035 630234 630295 630902 632562 775056 724243 740584 727751 729881 724230 733866 747281 748354 632593 644278 703039 710425 717798 424904 397535 427937 537888 539203 540573 537210 537212 537236 500971 518473 536744 514594 531123 533363 541853 545488 545611 553272 651674 677296 677777 678095 678522 680195 696606 650316 666880 666894 678097 680186 666868 677784 680176 680197 545372 614737 634134 634140 639334 600021 599865 617427 628380 628383 630869 588265 599835 600257 630552 634218 634780 478771 599940 526891 414364 818439 486470 453825 469373 475799 480293 480398 474837 495126 528761 530697 533521 534216 536178 536542 531248 532950 532974 533044 533931 536291 536620 500740 523418 531233 532166 532744 536550 540348 532965 533854 534999 537891 472431 542877 544854 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.37%) |
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 397535 414364 424904 427937 453825 469373 472431 474837 475799 478771 480293 480398 486470 495126 500740 500971 514594 518473 523418 526891 528761 530697 531123 531233 531248 532166 532744 532950 532965 532974 533044 533363 533521 533854 533931 534216 534999 536178 536291 536542 536550 536620 536744 537210 537212 537236 537888 537891 539203 540348 540573 541853 542877 544854 545372 545488 545611 553272 588265 599835 599865 599940 600021 600257 600269 605344 608035 614737 617427 628380 628383 630234 630295 630552 630857 630869 630902 632562 632593 632653 633776 634134 634140 634159 634169 634218 634780 636272 639334 641638 644278 650316 651674 666868 666880 666894 677296 677777 677784 678095 678097 678522 680176 680186 680195 680197 696606 703039 710425 717798 724230 724243 727751 729881 733866 740584 747281 748354 775056 818439 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг с двойным"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кастинг двойн"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.