Query Metrics
7
Database Queries
7
Different statements
156.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.69 ms (84.00%) |
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 418978 541324 542471 542502 542604 543495 543756 544206 544313 544468 545520 545528 545642 547892 547930 548289 549300 549856 550327 556795 557993 558008 560080 561353 562287 562824 562830 562840 562842 562848 563415 563533 563534 563540 566246 566297 566686 566695 566857 566865 566938 566952 567393 567728 567990 568026 568185 568287 568601 568954 569788 571242 571243 571439 572176 572556 573105 573761 573779 573905 574216 574247 575468 576420 576639 576681 576705 577177 577351 577363 577376 580775 581260 581315 581354 581386 581618 583902 584008 584244 586015 587795 589692 590696 590928 590948 592388 592486 592500 593514 595888 600320 601695 603041 605322 605324 605328 605330 617648 618299 619406 619470 619485 622830 644289 644310 644311 644321 644379 646336 649196 652577 670040 670112 693864 694119 699694 703039 706946 744259 ] |
||||||||||||||||||||||||||||||
|
14.51 ms (9.26%) |
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 571439 575468 576420 577363 584244 542502 549856 563533 566938 568026 569788 573761 583902 584008 543495 547892 557993 562287 562840 574247 576639 576705 581386 670040 699694 706946 646336 649196 652577 693864 694119 556795 562824 562848 563415 566865 572556 574216 581315 581354 586015 592486 592500 593514 600320 605324 590928 590948 619406 619470 644379 587795 592388 595888 601695 603041 617648 644321 589692 590696 605322 605328 605330 618299 619485 644311 744259 622830 644289 644310 703039 580775 418978 541324 543756 544206 544313 544468 545528 548289 562830 562842 566297 567393 567728 567990 568185 568601 568954 571242 577351 581260 542604 560080 563540 566686 566695 566857 571243 572176 573905 577177 577376 542471 545520 545642 547930 549300 558008 561353 563534 566246 566952 568287 573105 573779 576681 581618 670112 550327 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.09%) |
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 418978 541324 542471 542502 542604 543495 543756 544206 544313 544468 545520 545528 545642 547892 547930 548289 549300 549856 550327 556795 557993 558008 560080 561353 562287 562824 562830 562840 562842 562848 563415 563533 563534 563540 566246 566297 566686 566695 566857 566865 566938 566952 567393 567728 567990 568026 568185 568287 568601 568954 569788 571242 571243 571439 572176 572556 573105 573761 573779 573905 574216 574247 575468 576420 576639 576681 576705 577177 577351 577363 577376 580775 581260 581315 581354 581386 581618 583902 584008 584244 586015 587795 589692 590696 590928 590948 592388 592486 592500 593514 595888 600320 601695 603041 605322 605324 605328 605330 617648 618299 619406 619470 619485 622830 644289 644310 644311 644321 644379 646336 649196 652577 670040 670112 693864 694119 699694 703039 706946 744259 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro skinny"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр худые"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр худые"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.00%) |
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.