Query Metrics
7
Database Queries
7
Different statements
136.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.83 ms (83.39%) |
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 382815 383359 462043 462230 472797 542953 544482 547869 549306 549582 550014 550079 551319 551340 551417 552143 552151 552212 552463 554264 560592 560755 562201 562321 569875 569876 569891 570006 570229 570246 570269 570498 570565 570568 571301 571643 571648 571885 571908 572085 572151 572483 572484 573002 573110 578375 579110 580100 580673 584007 589103 591103 595402 596625 597811 600370 604633 609858 622391 622399 624835 639699 653187 654732 655116 655740 656081 656356 656452 656962 657366 657376 657935 658013 658051 658407 658650 659118 659120 659122 659151 659529 659594 659670 659795 659844 659859 660471 660568 660959 660973 666611 668842 668865 670172 671125 671141 672368 673455 675813 692788 698300 702404 709915 713139 714494 720168 723392 723943 724436 728072 729673 729804 730713 733334 735812 740325 747997 753904 ] |
||||||||||||||||||||||||||||||
|
12.77 ms (9.35%) |
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 660568 660959 668865 670172 671141 675813 655740 656081 656452 656962 657366 658051 658650 659118 659120 659122 659670 659795 660471 660973 666611 668842 672368 692788 713139 654732 655116 656356 657935 658013 658407 659151 659529 659594 659844 659859 671125 673455 723392 572484 579110 591103 639699 733334 740325 753904 723943 729804 735812 747997 730713 714494 622391 622399 624835 589103 597811 549582 552463 550079 551417 584007 702404 595402 728072 554264 562201 569875 569904 570246 571301 572151 573002 542953 549306 551340 552143 570006 571643 573110 552151 552212 570269 571885 571908 572483 578375 570498 572085 580100 580673 596625 604633 609858 383359 462230 653187 720168 657376 547869 551319 729673 724436 462043 382815 472797 550014 698300 709915 600370 560755 569891 570229 570565 570568 571648 544482 560592 562321 569876 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (2.16%) |
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 382815 383359 462043 462230 472797 542953 544482 547869 549306 549582 550014 550079 551319 551340 551417 552143 552151 552212 552463 554264 560592 560755 562201 562321 569875 569876 569891 570006 570229 570246 570269 570498 570565 570568 571301 571643 571648 571885 571908 572085 572151 572483 572484 573002 573110 578375 579110 580100 580673 584007 589103 591103 595402 596625 597811 600370 604633 609858 622391 622399 624835 639699 653187 654732 655116 655740 656081 656356 656452 656962 657366 657376 657935 658013 658051 658407 658650 659118 659120 659122 659151 659529 659594 659670 659795 659844 659859 660471 660568 660959 660973 666611 668842 668865 670172 671125 671141 672368 673455 675813 692788 698300 702404 709915 713139 714494 720168 723392 723943 724436 728072 729673 729804 730713 733334 735812 740325 747997 753904 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small and big"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая большие"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая большие"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.