Query Metrics
7
Database Queries
7
Different statements
395.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.46 ms (54.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск разговор"
]
|
||||||||||||||||||||||||||||||
|
156.21 ms (39.49%) |
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 420486 432173 439655 452978 456196 460760 462032 467198 476383 482843 483993 486190 488703 500055 502748 506223 506227 506246 508744 510249 513490 513501 513614 513616 516492 518822 519357 519738 521415 522446 522447 523595 523933 525233 527858 542711 544459 544971 547450 547796 551168 551210 552359 554565 558115 560018 562192 565004 565007 565008 568965 569588 569843 569902 570290 571393 571584 571929 572074 573973 574035 575265 575516 578026 578031 578054 579879 582548 587709 596169 596588 598493 603603 605011 610376 611932 613380 619947 621386 652892 655407 655704 657056 672842 672897 674288 677222 677407 680650 684679 688967 690478 692651 706851 713004 716852 719461 722266 722655 728453 733672 740051 741011 742643 744380 744860 764179 768462 768739 769017 769452 771289 779823 780514 787973 797765 799688 799725 803035 810187 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (3.67%) |
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 500055 508744 519357 569843 562192 573973 655704 657056 690478 722266 680650 692651 713004 551210 603603 613380 619947 779823 797765 799688 780514 740051 810187 744380 764179 768462 768739 769017 771289 605011 787973 799725 439655 462032 488703 621386 596588 420486 522446 486190 506223 506246 513501 516492 518822 522447 452978 560018 565004 569588 544971 551168 570290 571393 572074 672897 722655 688967 610376 611932 596169 803035 741011 742643 769452 733672 744860 728453 476383 482843 552359 568965 547796 574035 544459 565007 578026 578031 579879 587709 460760 456196 523933 513490 513614 483993 510249 519738 525233 565008 575265 432173 502748 506227 513616 521415 527858 467198 523595 547450 554565 571929 575516 578054 582548 542711 558115 569902 652892 674288 677407 706851 677222 716852 655407 672842 684679 719461 571584 598493 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.77%) |
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 420486 432173 439655 452978 456196 460760 462032 467198 476383 482843 483993 486190 488703 500055 502748 506223 506227 506246 508744 510249 513490 513501 513614 513616 516492 518822 519357 519738 521415 522446 522447 523595 523933 525233 527858 542711 544459 544971 547450 547796 551168 551210 552359 554565 558115 560018 562192 565004 565007 565008 568965 569588 569843 569902 570290 571393 571584 571929 572074 573973 574035 575265 575516 578026 578031 578054 579879 582548 587709 596169 596588 598493 603603 605011 610376 611932 613380 619947 621386 652892 655407 655704 657056 672842 672897 674288 677222 677407 680650 684679 688967 690478 692651 706851 713004 716852 719461 722266 722655 728453 733672 740051 741011 742643 744380 744860 764179 768462 768739 769017 769452 771289 779823 780514 787973 797765 799688 799725 803035 810187 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русских разговоров"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.