Query Metrics
7
Database Queries
7
Different statements
157.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.16 ms (82.74%) |
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 33711 61789 187643 191336 197443 392015 395254 395921 397986 399964 400509 401003 407291 407791 408136 411693 414987 418777 421851 421874 424067 424124 424871 426020 427009 428467 433356 433363 433820 435382 435937 437309 440164 442482 444915 445791 445874 448978 450272 451423 453239 453571 454459 454461 454967 455127 456720 456992 461034 461045 461810 464017 464039 464354 464987 465467 466748 466904 468370 468521 472568 473376 474116 475097 485686 485974 489381 491765 496512 501518 508697 509286 510502 512588 514103 514873 518857 520667 520761 523575 527418 530138 530444 534006 536282 537167 543366 546887 559356 561284 563144 566230 566874 569298 569632 580471 588404 590843 591696 591978 598061 600823 601953 604044 605588 607710 613708 614346 626376 626887 644849 663866 666138 668054 705424 725605 742398 769509 770237 795948 ] |
||||||||||||||||||||||||||||||
|
16.24 ms (10.32%) |
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 770237 725605 742398 769509 424067 411693 414987 407791 464354 455127 424124 666138 561284 613708 705424 421874 444915 509286 566230 530444 450272 461034 464987 453239 485974 537167 466904 626376 407291 465467 418777 424871 437309 605588 445874 453571 514873 426020 489381 485686 433356 442482 454459 468521 474116 448978 461810 451423 464039 472568 536282 510502 501518 508697 514103 520761 523575 534006 468370 563144 580471 569632 543366 559356 566874 663866 668054 546887 591978 604044 590843 614346 598061 600823 607710 601953 395921 392015 427009 428467 464017 421851 454461 454967 473376 518857 496512 512588 197443 397986 435937 445791 530138 588404 795948 433363 401003 433820 644849 491765 527418 520667 569298 408136 456720 591696 626887 466748 435382 461045 456992 440164 475097 400509 187643 191336 395254 33711 61789 399964 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.02%) |
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 33711 61789 187643 191336 197443 392015 395254 395921 397986 399964 400509 401003 407291 407791 408136 411693 414987 418777 421851 421874 424067 424124 424871 426020 427009 428467 433356 433363 433820 435382 435937 437309 440164 442482 444915 445791 445874 448978 450272 451423 453239 453571 454459 454461 454967 455127 456720 456992 461034 461045 461810 464017 464039 464354 464987 465467 466748 466904 468370 468521 472568 473376 474116 475097 485686 485974 489381 491765 496512 501518 508697 509286 510502 512588 514103 514873 518857 520667 520761 523575 527418 530138 530444 534006 536282 537167 543366 546887 559356 561284 563144 566230 566874 569298 569632 580471 588404 590843 591696 591978 598061 600823 601953 604044 605588 607710 613708 614346 626376 626887 644849 663866 666138 668054 705424 725605 742398 769509 770237 795948 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby panties"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
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.