Query Metrics
7
Database Queries
7
Different statements
178.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.93 ms (85.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 53801 187289 191315 318315 387520 390888 390987 391170 392789 393081 393690 395625 398559 400839 401248 404076 408164 408194 418692 420457 429895 439643 441001 442991 444527 445726 451967 452025 463841 466063 473453 476184 476186 478073 480538 485690 486535 486778 490511 495396 500414 503836 509437 509659 510882 511276 515272 522730 529778 530943 534285 536295 536521 555364 555403 555451 555464 559234 565804 568263 568269 576992 592578 593065 593521 596513 599207 602585 641337 660026 665217 670354 672919 701235 708541 710573 713153 715472 725420 725428 730073 730118 741211 741768 744188 744192 744379 747050 749023 749050 752621 755956 765476 767715 771361 771477 771485 784185 785831 785901 789616 790943 794215 794706 803490 803508 808341 817025 817172 818206 819227 819418 819671 825314 825426 826880 827001 827100 827327 827526 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (8.97%) |
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 393081 318315 452025 478073 509437 503836 486535 515272 522730 529778 420457 463841 510882 495396 534285 511276 390888 439643 441001 391170 398559 466063 500414 473453 476184 490511 530943 444527 429895 485690 191315 393690 392789 387520 390987 404076 819671 819227 825426 826880 827001 827100 827327 819418 817025 817172 825314 827526 486778 480538 536521 536295 509659 555464 555403 555451 559234 568263 665217 715472 660026 670354 672919 555364 565804 568269 576992 593521 602585 599207 641337 592578 593065 596513 785831 785901 790943 789616 794215 794706 803490 808341 725420 741211 749023 765476 771477 784185 744188 767715 771361 771485 725428 744379 749050 755956 730073 741768 744192 747050 730118 752621 701235 708541 710573 713153 803508 53801 187289 395625 400839 401248 408164 408194 418692 442991 818206 445726 451967 476186 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.36%) |
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 53801 187289 191315 318315 387520 390888 390987 391170 392789 393081 393690 395625 398559 400839 401248 404076 408164 408194 418692 420457 429895 439643 441001 442991 444527 445726 451967 452025 463841 466063 473453 476184 476186 478073 480538 485690 486535 486778 490511 495396 500414 503836 509437 509659 510882 511276 515272 522730 529778 530943 534285 536295 536521 555364 555403 555451 555464 559234 565804 568263 568269 576992 592578 593065 593521 596513 599207 602585 641337 660026 665217 670354 672919 701235 708541 710573 713153 715472 725420 725428 730073 730118 741211 741768 744188 744192 744379 747050 749023 749050 752621 755956 765476 767715 771361 771477 771485 784185 785831 785901 789616 790943 794215 794706 803490 803508 808341 817025 817172 818206 819227 819418 819671 825314 825426 826880 827001 827100 827327 827526 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toys mature"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toys mature"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toys mature"
]
|
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.