Query Metrics
7
Database Queries
7
Different statements
219.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.52 ms (88.17%) |
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 462118 462374 468322 491617 536132 536895 542015 542235 542727 543227 543268 543531 544022 544407 544700 544899 545149 545743 545919 546420 546431 547384 547707 548374 549419 549809 550149 550503 550912 550933 551033 551811 552171 552279 553334 554541 554699 555654 555763 556032 556864 557180 557263 558163 559632 560265 560503 560670 561878 562063 562529 563922 565620 567629 568337 568595 569275 569726 569772 569814 570360 570811 571127 571808 572475 573069 573231 573253 574158 575662 576001 576497 576729 576812 576880 576912 577128 577251 578175 578424 578466 578841 580226 580962 581382 581555 581629 581645 581731 582428 583403 584130 584678 645981 648591 648907 649023 649125 651163 651883 652203 652952 655074 655678 655938 656238 656372 657388 662410 662978 665094 667128 669583 670385 673523 675592 681239 686459 689846 690858 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (6.38%) |
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 536132 536895 462118 462374 468322 491617 542015 543227 543531 544022 545919 550149 553334 558163 560265 562529 568595 569814 570360 573231 573253 576001 576497 576729 576812 578175 578424 581645 583403 584130 542235 544899 545149 545743 546431 547384 548374 550933 551033 557263 559632 560670 561878 562063 563922 567629 569772 572475 573069 574158 575662 578466 580962 581629 581731 582428 584678 542727 543268 544407 546420 547707 550503 550912 552171 554541 555654 555763 556032 557180 568337 569726 570811 571808 576880 576912 577128 577251 578841 580226 581382 581555 648907 655678 656372 662410 675592 689846 690858 645981 649023 651883 652952 655074 655938 665094 667128 669583 670385 673523 648591 649125 651163 652203 656238 657388 662978 681239 686459 544700 549419 549809 551811 552279 554699 556864 560503 565620 569275 571127 ] |
||||||||||||||||||||||||||||||
|
5.17 ms (2.36%) |
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 462118 462374 468322 491617 536132 536895 542015 542235 542727 543227 543268 543531 544022 544407 544700 544899 545149 545743 545919 546420 546431 547384 547707 548374 549419 549809 550149 550503 550912 550933 551033 551811 552171 552279 553334 554541 554699 555654 555763 556032 556864 557180 557263 558163 559632 560265 560503 560670 561878 562063 562529 563922 565620 567629 568337 568595 569275 569726 569772 569814 570360 570811 571127 571808 572475 573069 573231 573253 574158 575662 576001 576497 576729 576812 576880 576912 577128 577251 578175 578424 578466 578841 580226 580962 581382 581555 581629 581645 581731 582428 583403 584130 584678 645981 648591 648907 649023 649125 651163 651883 652203 652952 655074 655678 655938 656238 656372 657388 662410 662978 665094 667128 669583 670385 673523 675592 681239 686459 689846 690858 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глад"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"глад"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"гладит"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.67%) |
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.