Query Metrics
7
Database Queries
7
Different statements
152.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.02 ms (82.90%) |
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 13166 75762 234239 386717 395266 402018 402969 403842 414334 432753 443506 443845 444109 445424 448171 451691 455766 461795 464573 467295 471122 472431 473699 481550 489839 491536 495379 497338 498200 499612 501522 503277 504562 506850 509424 514982 521726 526581 530469 530936 540097 540992 549557 558030 561721 563523 565375 567895 568070 571963 574476 574717 574842 575119 575758 586635 587965 589972 598695 600292 604101 609626 612255 612438 613261 617185 620453 630381 642527 652526 653180 653548 654463 654626 655407 663321 663332 666925 673662 675328 675378 684189 684359 687318 687862 688155 693299 695901 699130 699169 699551 701292 701713 703560 712433 716540 727128 736345 747237 752757 757345 769562 769743 770633 773683 777173 777921 779452 785777 786301 788672 791341 796986 797450 797817 799095 801003 813268 813387 ] |
||||||||||||||||||||||||||||||
|
13.92 ms (9.15%) |
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 609626 612438 613261 600292 620453 786301 788672 799095 801003 785777 813387 736345 747237 770633 791341 796986 797817 800948 752757 757345 769743 727128 769562 773683 617185 630381 642527 699551 701713 777173 777921 779452 797450 813268 473699 455766 395266 386717 402018 402969 443506 432753 526581 491536 495379 498200 472431 568070 567895 716540 654463 571963 587965 589972 586635 598695 604101 612255 467295 471122 445424 461795 501522 497338 499612 503277 514982 234239 75762 13166 403842 444109 414334 443845 489839 448171 451691 481550 504562 506850 509424 521726 530469 530936 540097 464573 565375 574476 575119 558030 563523 574717 540992 549557 561721 574842 575758 652526 653180 653548 663321 663332 673662 675378 684359 688155 693299 699169 712433 666925 675328 684189 695901 699130 701292 654626 655407 687318 687862 703560 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая милая"
]
|
||||||||||||||||||||||||||||||
|
2.41 ms (1.59%) |
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 13166 75762 234239 386717 395266 402018 402969 403842 414334 432753 443506 443845 444109 445424 448171 451691 455766 461795 464573 467295 471122 472431 473699 481550 489839 491536 495379 497338 498200 499612 501522 503277 504562 506850 509424 514982 521726 526581 530469 530936 540097 540992 549557 558030 561721 563523 565375 567895 568070 571963 574476 574717 574842 575119 575758 586635 587965 589972 598695 600292 604101 609626 612255 612438 613261 617185 620453 630381 642527 652526 653180 653548 654463 654626 655407 663321 663332 666925 673662 675328 675378 684189 684359 687318 687862 688155 693299 695901 699130 699169 699551 701292 701713 703560 712433 716540 727128 736345 747237 752757 757345 769562 769743 770633 773683 777173 777921 779452 785777 786301 788672 791341 796986 797450 797817 799095 801003 813268 813387 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sweet"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая милая"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.25%) |
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.