Query Metrics
7
Database Queries
7
Different statements
607.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
575.64 ms (94.81%) |
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 96100 96800 97098 97401 109313 123921 130089 130429 130506 282858 308783 325910 383387 388254 388492 390538 394597 396334 397273 397302 400956 414360 414374 420471 421264 424634 429793 451866 452018 461723 463122 467611 474654 474689 474693 483542 495218 500363 510180 520413 520753 521249 525864 530792 532662 532667 534151 541863 543858 550750 565262 565263 565351 566786 592034 600366 601512 604331 614995 617417 617422 617424 617652 622817 623510 624189 627806 628374 629560 629886 630295 630679 630764 632579 632628 632638 633736 633741 633776 634161 634169 639254 639797 641413 643020 644972 646901 650827 662020 668527 670965 671739 675007 677296 677676 678117 679798 680192 695125 696229 697025 699694 705144 707262 714552 716043 716892 716901 741283 742226 746994 748951 756023 756092 762257 775818 775858 784161 810061 821532 ] |
||||||||||||||||||||||||||||||
|
20.80 ms (3.43%) |
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 756092 762257 742226 741283 756023 623510 707262 775818 784161 397302 109313 130089 424634 483542 541863 678117 716901 675007 677676 565262 592034 633736 633741 628374 617424 474693 461723 525864 451866 565351 566786 627806 390538 414374 463122 520413 614995 622817 617422 474654 474689 520753 452018 383387 420471 421264 644972 680192 699694 679798 668527 695125 697025 600366 634169 629560 629886 633776 630295 639254 775858 748951 746994 601512 714552 810061 396334 550750 429793 716043 716892 624189 467611 646901 677296 643020 617417 632579 123921 325910 308783 96800 400956 130506 394597 97098 97401 388492 414360 821532 521249 530792 534151 565263 650827 670965 671739 617652 634161 630679 397273 282858 532667 500363 630764 632628 510180 632638 639797 641413 532662 662020 495218 696229 604331 388254 705144 543858 130429 96100 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.51%) |
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 96100 96800 97098 97401 109313 123921 130089 130429 130506 282858 308783 325910 383387 388254 388492 390538 394597 396334 397273 397302 400956 414360 414374 420471 421264 424634 429793 451866 452018 461723 463122 467611 474654 474689 474693 483542 495218 500363 510180 520413 520753 521249 525864 530792 532662 532667 534151 541863 543858 550750 565262 565263 565351 566786 592034 600366 601512 604331 614995 617417 617422 617424 617652 622817 623510 624189 627806 628374 629560 629886 630295 630679 630764 632579 632628 632638 633736 633741 633776 634161 634169 639254 639797 641413 643020 644972 646901 650827 662020 668527 670965 671739 675007 677296 677676 678117 679798 680192 695125 696229 697025 699694 705144 707262 714552 716043 716892 716901 741283 742226 746994 748951 756023 756092 762257 775818 775858 784161 810061 821532 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal gangbang group"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (0.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал gangbang group"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал gangbang group"
]
|
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.