Query Metrics
7
Database Queries
7
Different statements
143.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.52 ms (82.54%) |
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 81588 400441 400459 413252 428523 458025 463166 464281 467214 467344 468805 473913 484129 488309 492595 494362 495144 503870 515194 515195 515201 517195 518981 520251 520718 520774 523258 530392 534126 539519 542934 543547 543822 544301 545528 548092 549912 550443 550612 557310 559705 560405 560427 562804 565107 566986 567150 569684 570052 570056 578457 578468 578477 580399 585603 588408 596543 597869 598013 600793 617135 618422 622068 624664 629902 635897 655685 655691 656381 657730 657949 658066 658419 659601 663437 664845 665397 670074 673985 675510 675737 676472 697307 701039 702667 703113 712913 713037 714447 719143 720825 721434 726446 730556 736824 737439 741289 742162 743132 744298 744941 751648 755512 756067 756521 759645 760769 788269 788963 789886 793549 804113 810609 814138 817335 818370 818406 819550 821625 825691 ] |
||||||||||||||||||||||||||||||
|
15.16 ms (10.56%) |
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 737439 744298 744941 756067 629902 701039 702667 703113 804113 810609 413252 597869 520774 550443 676472 515201 515194 818406 825691 622068 793549 759645 743132 736824 713037 719143 464281 400459 697307 751648 428523 458025 560427 578468 664845 463166 473913 467344 523258 817335 814138 675510 756521 760769 484129 557310 488309 515195 534126 517195 495144 565107 570052 542934 543547 578477 566986 720825 569684 570056 600793 585603 598013 588408 596543 617135 624664 788269 400441 503870 520251 520718 494362 492595 818370 81588 819550 821625 539519 530392 543822 550612 549912 544301 657730 658066 655691 657949 658419 673985 712913 655685 656381 659601 670074 675737 721434 559705 635897 788963 789886 755512 730556 618422 741289 742162 726446 467214 468805 518981 545528 562804 578457 548092 560405 567150 580399 663437 714447 665397 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.68%) |
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 81588 400441 400459 413252 428523 458025 463166 464281 467214 467344 468805 473913 484129 488309 492595 494362 495144 503870 515194 515195 515201 517195 518981 520251 520718 520774 523258 530392 534126 539519 542934 543547 543822 544301 545528 548092 549912 550443 550612 557310 559705 560405 560427 562804 565107 566986 567150 569684 570052 570056 578457 578468 578477 580399 585603 588408 596543 597869 598013 600793 617135 618422 622068 624664 629902 635897 655685 655691 656381 657730 657949 658066 658419 659601 663437 664845 665397 670074 673985 675510 675737 676472 697307 701039 702667 703113 712913 713037 714447 719143 720825 721434 726446 730556 736824 737439 741289 742162 743132 744298 744941 751648 755512 756067 756521 759645 760769 788269 788963 789886 793549 804113 810609 814138 817335 818370 818406 819550 821625 825691 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young girl"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.14%) |
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.