Query Metrics
7
Database Queries
7
Different statements
369.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
343.23 ms (92.94%) |
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 170836 188669 232953 233269 233512 239599 257966 382549 382657 382937 382971 388765 389211 389895 390929 393706 395271 395878 395955 396887 397878 405810 409942 411717 411722 411723 445744 449078 452415 454274 460451 466247 466821 474846 474861 474876 476306 484619 487360 517589 539358 540263 549240 551021 556451 556490 557148 560414 561598 562596 604048 605460 610067 614476 614519 645840 663381 663460 663466 663965 665187 665219 665284 665288 665317 665379 665448 665457 665483 665857 665875 666163 666828 667474 667498 667532 667859 667878 680704 707282 710579 714646 716586 717711 721377 721449 721463 722240 723377 728451 730367 731803 736386 744987 748389 770149 774766 780609 781652 781686 781702 781745 781746 781747 784669 785939 788212 789292 808224 814125 816792 817308 818449 820283 820298 820384 823691 823915 824023 827054 ] |
||||||||||||||||||||||||||||||
|
15.06 ms (4.08%) |
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 731803 808224 474876 411723 388765 484619 466821 389895 382971 411717 487360 474861 562596 389211 390929 188669 466247 409942 233512 820298 540263 551021 666163 396887 817308 665483 645840 781747 789292 716586 774766 382937 239599 382657 814125 818449 784669 397878 405810 474846 476306 449078 452415 460451 517589 556490 549240 665288 665317 665448 665457 667474 667878 663381 663466 666828 667498 667859 663460 663965 665187 665284 665379 665875 667532 723377 556451 610067 605460 788212 744987 770149 604048 445744 395878 411722 382549 748389 454274 257966 816792 823691 820283 539358 557148 560414 561598 707282 714646 170836 232953 395271 820384 824023 823915 721377 665219 721449 721463 680704 710579 614476 614519 781746 781702 736386 717711 722240 781652 781686 781745 233269 395955 393706 665857 780609 785939 730367 827054 728451 ] |
||||||||||||||||||||||||||||||
|
4.25 ms (1.15%) |
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 170836 188669 232953 233269 233512 239599 257966 382549 382657 382937 382971 388765 389211 389895 390929 393706 395271 395878 395955 396887 397878 405810 409942 411717 411722 411723 445744 449078 452415 454274 460451 466247 466821 474846 474861 474876 476306 484619 487360 517589 539358 540263 549240 551021 556451 556490 557148 560414 561598 562596 604048 605460 610067 614476 614519 645840 663381 663460 663466 663965 665187 665219 665284 665288 665317 665379 665448 665457 665483 665857 665875 666163 666828 667474 667498 667532 667859 667878 680704 707282 710579 714646 716586 717711 721377 721449 721463 722240 723377 728451 730367 731803 736386 744987 748389 770149 774766 780609 781652 781686 781702 781745 781746 781747 784669 785939 788212 789292 808224 814125 816792 817308 818449 820283 820298 820384 823691 823915 824023 827054 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature old"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature old"
]
|
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.