Query Metrics
7
Database Queries
7
Different statements
148.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.23 ms (82.92%) |
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 89480 382134 384124 384752 390351 395637 397219 398545 403324 405859 406648 407780 407809 407819 409371 409934 411352 411704 411761 412983 437530 439721 439752 443761 443768 443772 443782 448708 451469 453145 454177 454194 454247 454886 457515 458000 460757 460762 460923 466051 466244 466893 467124 467279 470017 470768 472608 474479 474480 474482 474490 476284 479047 479098 479104 479115 483646 484399 484594 484621 484625 490197 492062 493177 497205 497506 508736 515841 515905 515912 518871 518909 519306 520899 522486 522508 523164 523845 523874 535439 536457 538006 546119 549224 549842 550220 556630 557572 566327 566928 566940 567342 591977 632268 664846 666770 667615 699707 714169 716487 724252 726756 727769 728385 731755 731772 731836 734015 741764 744906 769580 780625 781914 789536 790885 799360 806084 808527 810834 814933 ] |
||||||||||||||||||||||||||||||
|
15.24 ms (10.25%) |
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 398545 405859 411761 407780 407809 407819 409934 412983 814933 467124 454886 460923 474479 484399 523164 518871 522486 460762 566940 567342 546119 556630 557572 549224 549842 550220 566327 566928 591977 632268 790885 806084 789536 724252 808527 727769 741764 728385 699707 781914 799360 810834 409371 411352 448708 457515 466051 466893 470768 474490 390351 439721 439752 443768 454247 467279 474480 474482 476284 479047 479098 479104 403324 437530 451469 460757 479115 384124 406648 411704 454177 458000 466244 470017 443761 443772 443782 454194 520899 523874 536457 538006 484594 484625 492062 515905 515912 518909 519306 523845 490197 497205 508736 522508 483646 484621 493177 515841 535439 780625 497506 716487 714169 664846 666770 667615 726756 731772 734015 731836 731755 744906 769580 397219 89480 384752 395637 382134 453145 472608 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.74%) |
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 89480 382134 384124 384752 390351 395637 397219 398545 403324 405859 406648 407780 407809 407819 409371 409934 411352 411704 411761 412983 437530 439721 439752 443761 443768 443772 443782 448708 451469 453145 454177 454194 454247 454886 457515 458000 460757 460762 460923 466051 466244 466893 467124 467279 470017 470768 472608 474479 474480 474482 474490 476284 479047 479098 479104 479115 483646 484399 484594 484621 484625 490197 492062 493177 497205 497506 508736 515841 515905 515912 518871 518909 519306 520899 522486 522508 523164 523845 523874 535439 536457 538006 546119 549224 549842 550220 556630 557572 566327 566928 566940 567342 591977 632268 664846 666770 667615 699707 714169 716487 724252 726756 727769 728385 731755 731772 731836 734015 741764 744906 769580 780625 781914 789536 790885 799360 806084 808527 810834 814933 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big but"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.19%) |
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.