Query Metrics
7
Database Queries
7
Different statements
150.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.21 ms (81.75%) |
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 7727 9732 10209 20886 32620 32923 74588 88274 112637 123751 133698 145603 205443 256487 280493 371547 385064 389505 390493 396834 399410 400843 403085 404261 404413 404428 414866 417406 417772 418858 419794 420619 426407 429819 430110 431496 436645 437104 438979 440629 445580 448051 448886 454078 455493 456901 457653 461670 465423 465474 466675 469997 473656 475814 478554 482169 483322 483477 483478 485856 492516 492788 495473 497244 498378 510664 512321 513199 520706 525305 541102 541847 543198 545858 546639 548703 552197 553997 558398 560341 560625 566671 567526 568135 568834 570196 575209 582137 584320 584332 586497 586546 591601 610648 622582 629362 631676 658193 664230 664267 675551 699870 706596 733900 736826 743297 748997 756371 757353 774664 776392 781360 782645 783206 784874 801384 805314 811483 814626 817956 ] |
||||||||||||||||||||||||||||||
|
15.51 ms (10.29%) |
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 429819 582137 586497 10209 389505 32620 133698 483322 419794 675551 756371 280493 568834 706596 631676 541847 417406 396834 448886 498378 483477 20886 7727 783206 736826 417772 568135 584332 781360 404428 817956 548703 748997 454078 461670 495473 510664 545858 541102 205443 123751 455493 426407 404413 512321 776392 699870 112637 437104 622582 403085 478554 520706 456901 371547 465423 591601 385064 145603 733900 811483 757353 404261 399410 575209 664267 805314 88274 256487 543198 414866 610648 448051 782645 743297 492788 431496 482169 492516 567526 629362 390493 457653 658193 664230 32923 9732 74588 440629 774664 784874 466675 469997 465474 525305 801384 814626 473656 546639 560341 553997 400843 438979 445580 483478 485856 513199 570196 436645 584320 420619 430110 475814 560625 566671 558398 586546 418858 497244 552197 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.01%) |
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 7727 9732 10209 20886 32620 32923 74588 88274 112637 123751 133698 145603 205443 256487 280493 371547 385064 389505 390493 396834 399410 400843 403085 404261 404413 404428 414866 417406 417772 418858 419794 420619 426407 429819 430110 431496 436645 437104 438979 440629 445580 448051 448886 454078 455493 456901 457653 461670 465423 465474 466675 469997 473656 475814 478554 482169 483322 483477 483478 485856 492516 492788 495473 497244 498378 510664 512321 513199 520706 525305 541102 541847 543198 545858 546639 548703 552197 553997 558398 560341 560625 566671 567526 568135 568834 570196 575209 582137 584320 584332 586497 586546 591601 610648 622582 629362 631676 658193 664230 664267 675551 699870 706596 733900 736826 743297 748997 756371 757353 774664 776392 781360 782645 783206 784874 801384 805314 811483 814626 817956 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая большие"
]
|
||||||||||||||||||||||||||||||
|
2.34 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful big"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.