Query Metrics
7
Database Queries
7
Different statements
160.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.24 ms (81.79%) |
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 313187 315513 370875 379559 386936 389567 391592 392602 394243 395662 396534 397998 398946 407529 409053 421989 422147 424125 427800 434125 441956 442647 449079 450807 451711 452816 455273 459783 466384 467083 468982 470871 472583 474891 476253 477950 478986 480833 483496 483654 489127 491934 495582 496112 500690 504345 506014 510953 513076 514394 517180 517933 520677 522231 524626 525158 526518 533963 535823 541561 541890 541897 542449 549236 549367 549391 556817 560392 561590 563009 563419 563455 564127 565022 565986 568465 569015 569145 570405 573739 577363 580971 581566 581969 604556 606733 632289 650195 654636 661976 720943 721812 773255 775545 778385 783959 787298 788818 793404 795163 799383 806784 809486 814783 814844 814912 814930 815214 815442 816073 816115 816582 816958 817855 818426 818472 821036 821449 823622 823809 ] |
||||||||||||||||||||||||||||||
|
18.46 ms (11.50%) |
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 773255 604556 606733 632289 720943 721812 775545 778385 783959 787298 788818 793404 795163 799383 806784 809486 313187 379559 442647 451711 386936 389567 395662 397998 409053 422147 474891 392602 396534 398946 407529 441956 459783 477950 478986 424125 427800 480833 470871 504345 514394 500690 506014 491934 483654 495582 510953 525158 421989 513076 394243 391592 315513 370875 434125 814930 815442 816073 818426 818472 823809 816115 817855 814783 814844 814912 815214 816582 816958 821036 821449 823622 450807 449079 483496 452816 455273 468982 489127 517180 520677 522231 517933 535823 526518 496112 524626 533963 466384 467083 472583 476253 541897 549236 556817 561590 564127 565986 568465 569015 569145 577363 580971 541561 563419 565022 570405 573739 541890 542449 549367 549391 560392 563009 563455 581566 581969 650195 654636 661976 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.88%) |
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 313187 315513 370875 379559 386936 389567 391592 392602 394243 395662 396534 397998 398946 407529 409053 421989 422147 424125 427800 434125 441956 442647 449079 450807 451711 452816 455273 459783 466384 467083 468982 470871 472583 474891 476253 477950 478986 480833 483496 483654 489127 491934 495582 496112 500690 504345 506014 510953 513076 514394 517180 517933 520677 522231 524626 525158 526518 533963 535823 541561 541890 541897 542449 549236 549367 549391 556817 560392 561590 563009 563419 563455 564127 565022 565986 568465 569015 569145 570405 573739 577363 580971 581566 581969 604556 606733 632289 650195 654636 661976 720943 721812 773255 775545 778385 783959 787298 788818 793404 795163 799383 806784 809486 814783 814844 814912 814930 815214 815442 816073 816115 816582 816958 817855 818426 818472 821036 821449 823622 823809 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom in shower"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom shower"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom shower"
]
|
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.