Query Metrics
7
Database Queries
7
Different statements
187.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.27 ms (85.46%) |
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 186948 386623 390508 390951 421343 423858 424646 435318 435487 444753 453825 457267 458784 458791 460178 462546 463278 471326 483056 495292 497688 497859 498368 508051 510220 516070 522161 522446 523803 527225 528429 528597 528832 532918 533849 535042 541994 542067 546994 550302 550305 557487 557551 559332 559526 561289 564263 565929 566187 566413 568185 572214 573749 573756 579848 580771 582459 589598 590325 600316 611561 614020 620879 623620 625594 629273 629400 632021 634297 635949 650845 652945 653972 654562 656639 656815 663172 668501 670205 670763 673583 681288 693076 693077 706934 710485 713565 719808 721541 722827 730497 732074 742677 742683 748239 748241 748252 748432 751026 753505 755011 755170 755219 758281 761102 762885 762907 766734 781447 790739 795138 799941 800373 802277 804468 809931 809932 814741 814781 814883 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (8.69%) |
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 804468 732074 748239 748241 748252 751026 766734 742677 748432 755011 761102 755219 758281 762907 730497 753505 629400 706934 721541 722827 781447 795138 390951 424646 458784 435318 471326 386623 421343 423858 462546 460178 516070 497859 522446 483056 495292 528429 498368 522161 186948 390508 435487 444753 814741 814781 814883 458791 453825 457267 497688 510220 523803 533849 527225 528597 528832 508051 532918 535042 463278 559526 566413 568185 541994 542067 546994 557487 565929 573749 582459 550305 557551 561289 580771 670205 670763 673583 713565 719808 653972 654562 656815 663172 693076 650845 652945 656639 668501 681288 693077 710485 550302 559332 564263 566187 572214 573756 579848 611561 620879 589598 629273 634297 600316 614020 635949 590325 623620 625594 632021 799941 809931 802277 809932 742683 755170 762885 790739 800373 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.67%) |
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 186948 386623 390508 390951 421343 423858 424646 435318 435487 444753 453825 457267 458784 458791 460178 462546 463278 471326 483056 495292 497688 497859 498368 508051 510220 516070 522161 522446 523803 527225 528429 528597 528832 532918 533849 535042 541994 542067 546994 550302 550305 557487 557551 559332 559526 561289 564263 565929 566187 566413 568185 572214 573749 573756 579848 580771 582459 589598 590325 600316 611561 614020 620879 623620 625594 629273 629400 632021 634297 635949 650845 652945 653972 654562 656639 656815 663172 668501 670205 670763 673583 681288 693076 693077 706934 710485 713565 719808 721541 722827 730497 732074 742677 742683 748239 748241 748252 748432 751026 753505 755011 755170 755219 758281 761102 762885 762907 766734 781447 790739 795138 799941 800373 802277 804468 809931 809932 814741 814781 814883 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"делится"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дел"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.90%) |
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.