Query Metrics
7
Database Queries
7
Different statements
206.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
178.11 ms (86.13%) |
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 7335 190925 388856 396404 397526 399641 399652 399662 399688 399694 399931 401470 401617 402375 404279 405806 409045 409300 417629 418865 424811 425762 426384 426414 427537 428347 430695 456618 474141 476101 478036 479800 480383 480397 480787 485132 498593 499857 515768 535016 553292 570978 593436 600819 815184 815194 815196 815202 815208 815212 815214 815232 815237 815252 815255 815278 815290 815299 815304 815305 815314 815330 815347 815357 815367 815370 815383 815406 815410 815417 815427 815449 815471 815473 815490 815492 815516 815545 815547 815559 815566 815567 815568 815594 815598 815608 815617 815699 815705 815708 815714 815718 815752 815755 815847 815851 815865 815869 815875 815881 815885 815886 815897 815925 815928 815959 815969 816007 816065 816067 816087 816249 816259 816261 816499 816565 816569 816949 816968 821532 ] |
||||||||||||||||||||||||||||||
|
17.71 ms (8.57%) |
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 190925 401617 402375 405806 409045 426414 476101 535016 397526 425762 409300 815305 815357 815367 815516 815547 815617 815714 815897 815194 815304 815608 815755 815969 816067 816261 816968 815214 815299 815449 815471 815559 815699 815708 815718 815869 816087 816565 815184 815208 815212 815237 815347 815406 815567 815705 815752 815847 815865 815875 815925 815928 816259 821532 474141 480383 515768 593436 399694 401470 479800 399662 399931 418865 428347 430695 498593 485132 456618 399652 426384 427537 815370 815410 815290 815314 815417 815473 815598 816249 815196 815202 815252 815545 815566 815568 815594 816065 815255 815383 815427 815851 478036 553292 570978 600819 388856 417629 424811 396404 399688 404279 7335 480787 480397 499857 399641 816949 815330 815490 815881 815885 815886 816569 815232 815278 815492 815959 816007 816499 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.65%) |
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 7335 190925 388856 396404 397526 399641 399652 399662 399688 399694 399931 401470 401617 402375 404279 405806 409045 409300 417629 418865 424811 425762 426384 426414 427537 428347 430695 456618 474141 476101 478036 479800 480383 480397 480787 485132 498593 499857 515768 535016 553292 570978 593436 600819 815184 815194 815196 815202 815208 815212 815214 815232 815237 815252 815255 815278 815290 815299 815304 815305 815314 815330 815347 815357 815367 815370 815383 815406 815410 815417 815427 815449 815471 815473 815490 815492 815516 815545 815547 815559 815566 815567 815568 815594 815598 815608 815617 815699 815705 815708 815714 815718 815752 815755 815847 815851 815865 815869 815875 815881 815885 815886 815897 815925 815928 815959 815969 816007 816065 816067 816087 816249 816259 816261 816499 816565 816569 816949 816968 821532 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom brazzers"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.79%) |
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.