Query Metrics
7
Database Queries
7
Different statements
221.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.73 ms (87.49%) |
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 7157 190869 383595 383650 385474 385486 387742 388856 397526 399604 399633 399659 399923 401052 401470 407396 407627 418865 426414 426464 429368 430695 446135 447166 448363 448962 462425 466958 468545 478036 479802 480381 480398 484205 485132 498593 499857 515768 645349 806138 806174 807385 815184 815195 815214 815236 815256 815263 815264 815299 815304 815317 815339 815347 815365 815369 815406 815412 815425 815448 815450 815454 815469 815474 815478 815516 815531 815540 815559 815583 815598 815608 815617 815699 815714 815721 815723 815742 815752 815759 815768 815793 815797 815841 815847 815865 815869 815875 815895 815897 815904 815952 815958 815973 815979 815980 815995 816001 816025 816035 816040 816060 816067 816083 816259 816326 816360 816451 816497 816510 816513 816524 816534 816536 816893 816905 816968 816990 817396 821532 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (7.36%) |
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 815531 815768 815797 816001 816035 816083 816497 815973 815979 816534 816893 815195 815721 815793 815958 815980 7157 399923 815723 816360 448962 480381 479802 806138 426414 815412 815469 383595 815516 815617 815299 815865 816259 468545 401470 407396 480398 478036 388856 815454 816513 387742 815714 815897 815304 815608 816067 816968 815214 815559 815699 815869 815184 815347 815406 815752 815847 815875 821532 515768 418865 430695 485132 448363 815317 815450 815256 815448 815583 815742 816025 816040 816451 816990 815474 815478 815895 815904 815952 815995 816524 817396 815339 815369 815425 815540 816060 645349 806174 815365 399604 815236 815264 816510 401052 466958 499857 383650 397526 399659 429368 816905 815759 446135 462425 385486 407627 447166 498593 484205 190869 399633 815263 816326 816536 815841 807385 426464 815598 385474 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (1.85%) |
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 7157 190869 383595 383650 385474 385486 387742 388856 397526 399604 399633 399659 399923 401052 401470 407396 407627 418865 426414 426464 429368 430695 446135 447166 448363 448962 462425 466958 468545 478036 479802 480381 480398 484205 485132 498593 499857 515768 645349 806138 806174 807385 815184 815195 815214 815236 815256 815263 815264 815299 815304 815317 815339 815347 815365 815369 815406 815412 815425 815448 815450 815454 815469 815474 815478 815516 815531 815540 815559 815583 815598 815608 815617 815699 815714 815721 815723 815742 815752 815759 815768 815793 815797 815841 815847 815865 815869 815875 815895 815897 815904 815952 815958 815973 815979 815980 815995 816001 816025 816035 816040 816060 816067 816083 816259 816326 816360 816451 816497 816510 816513 816524 816534 816536 816893 816905 816968 816990 817396 821532 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brazzers mother"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brazzers мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"brazzers мам женщин"
]
|
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.