Query Metrics
7
Database Queries
7
Different statements
246.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
220.32 ms (89.27%) |
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 1061 39532 80365 383246 387005 388080 398789 405151 407222 409941 413257 418430 422371 428342 429754 457067 458945 459445 459685 466806 469361 475464 484431 486290 486886 488891 489254 491116 497739 502543 503768 506049 509898 511126 512618 514120 515300 517835 518161 519937 520075 521204 521422 521718 521781 521826 525149 525450 528287 529996 530194 534620 535255 540623 541313 542108 542565 542940 548820 551009 551189 552380 553611 555089 555417 556326 557091 557660 561005 565900 567608 568681 569253 572318 573506 573757 574402 574421 576819 577778 580195 588094 588508 588722 588896 588984 589026 593810 595043 597843 599332 601423 602480 607901 610081 614442 615716 623436 623854 624489 625880 634614 635697 636497 643098 653330 662476 671355 676911 682943 689763 709900 724678 767839 781617 782557 788338 793315 794930 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (6.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 561005 588984 548820 557091 39532 551009 793315 781617 418430 588094 567608 597843 428342 486290 409941 525149 521718 689763 506049 577778 572318 595043 514120 503768 552380 569253 623436 525450 405151 573506 636497 459445 542565 623854 535255 588722 551189 589026 607901 80365 1061 512618 515300 576819 682943 767839 413257 398789 469361 466806 634614 519937 615716 457067 530194 565900 568681 574402 580195 653330 593810 601423 505794 624489 387005 388080 458945 497739 542940 724678 794930 383246 521204 574421 429754 489254 521826 517835 518161 520075 521422 528287 529996 534620 540623 491116 553611 573757 782557 407222 459685 422371 509898 486886 511126 555089 475464 542108 557660 556326 662476 610081 588896 602480 635697 625880 614442 676911 488891 484431 521781 541313 555417 671355 599332 588508 788338 709900 643098 502543 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (1.49%) |
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 1061 39532 80365 383246 387005 388080 398789 405151 407222 409941 413257 418430 422371 428342 429754 457067 458945 459445 459685 466806 469361 475464 484431 486290 486886 488891 489254 491116 497739 502543 503768 506049 509898 511126 512618 514120 515300 517835 518161 519937 520075 521204 521422 521718 521781 521826 525149 525450 528287 529996 530194 534620 535255 540623 541313 542108 542565 542940 548820 551009 551189 552380 553611 555089 555417 556326 557091 557660 561005 565900 567608 568681 569253 572318 573506 573757 574402 574421 576819 577778 580195 588094 588508 588722 588896 588984 589026 593810 595043 597843 599332 601423 602480 607901 610081 614442 615716 623436 623854 624489 625880 634614 635697 636497 643098 653330 662476 671355 676911 682943 689763 709900 724678 767839 781617 782557 788338 793315 794930 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"яйца в рот"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"яйц в рот"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.64%) |
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.