Query Metrics
7
Database Queries
7
Different statements
362.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
336.29 ms (92.70%) |
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 525529 538837 541324 542942 543725 543825 544206 544254 544295 544305 546611 546779 547930 549300 549774 550033 550336 561007 562824 562826 563196 563462 566146 566170 566297 566886 566952 567391 567429 568341 572579 573779 574204 574216 574247 574292 577350 577377 581260 581323 581349 581380 583856 583872 586015 586813 590919 592426 592512 593514 599011 601172 605322 605324 605325 605328 605330 610952 619394 619406 621025 622374 622977 624357 624394 627748 628301 628308 628310 628328 630309 635191 644291 649081 649154 649190 649191 650570 651190 653300 663507 670103 670112 672175 672805 680633 683567 691992 691995 692169 693864 694034 694119 695629 697230 697263 697806 698557 699335 705878 706899 707265 707280 708468 716078 716244 716659 716835 720819 727747 742610 744259 744294 750410 753257 775811 784247 790392 790394 819506 ] |
||||||||||||||||||||||||||||||
|
15.60 ms (4.30%) |
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 601172 624394 742610 744294 707265 775811 542942 543725 543825 566170 566886 568341 574292 581323 546611 581380 683567 694034 653300 697230 698557 716835 649190 670103 697263 716078 720819 563462 572579 583872 592426 628310 628328 644291 605325 610952 622374 622977 628308 586813 599011 627748 621025 790394 750410 753257 624357 628301 697806 706899 546779 577377 790392 525529 583856 663507 544305 561007 574247 649191 680633 695629 705878 691992 693864 694119 716244 708468 549774 562824 567391 574216 586015 593514 605324 619394 635191 590919 619406 592512 605322 605328 605330 630309 784247 727747 744259 716659 574204 567429 562826 566146 577350 550033 581349 550336 819506 538837 541324 544206 566297 581260 544254 563196 544295 547930 549300 566952 573779 649154 650570 672175 691995 699335 707280 670112 649081 651190 672805 692169 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.85%) |
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 525529 538837 541324 542942 543725 543825 544206 544254 544295 544305 546611 546779 547930 549300 549774 550033 550336 561007 562824 562826 563196 563462 566146 566170 566297 566886 566952 567391 567429 568341 572579 573779 574204 574216 574247 574292 577350 577377 581260 581323 581349 581380 583856 583872 586015 586813 590919 592426 592512 593514 599011 601172 605322 605324 605325 605328 605330 610952 619394 619406 621025 622374 622977 624357 624394 627748 628301 628308 628310 628328 630309 635191 644291 649081 649154 649190 649191 650570 651190 653300 663507 670103 670112 672175 672805 680633 683567 691992 691995 692169 693864 694034 694119 695629 697230 697263 697806 698557 699335 705878 706899 707265 707280 708468 716078 716244 716659 716835 720819 727747 742610 744259 744294 750410 753257 775811 784247 790392 790394 819506 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"vintage old мужчин"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"vintage old мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"vintage old man"
]
|
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.