Query Metrics
7
Database Queries
7
Different statements
166.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.43 ms (81.58%) |
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 7213 123541 185109 194687 271638 278236 311734 327786 384551 385955 387175 388350 388551 392672 397209 397763 397766 400938 407250 409931 410836 413062 413240 416335 416346 417005 420869 421037 421189 421492 421792 424207 426920 426990 429065 429185 431167 434914 437019 438712 439146 439264 439345 441166 442444 444515 445078 446509 447405 450585 450647 450765 450854 451541 451691 452372 452596 453033 453831 454028 454643 455588 456209 456234 457694 458055 458098 458362 460251 460318 462231 463174 464284 464443 465411 466105 467223 467992 469036 469197 471346 471526 472587 472873 475606 476149 477848 478519 480242 483329 488528 488679 489210 490168 491602 501730 503082 503155 504564 506072 509847 509916 510495 512293 512586 512647 513675 521869 523505 538224 539155 539463 558045 558618 571736 587054 587587 622297 696126 809217 ] |
||||||||||||||||||||||||||||||
|
18.59 ms (11.20%) |
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 444515 439146 458362 488679 510495 506072 467223 558618 809217 327786 458098 426920 441166 469197 480242 392672 421189 387175 467992 472587 421037 512293 512647 503082 513675 509916 538224 384551 397209 413062 409931 451691 452596 456209 465411 475606 503155 469036 571736 587054 453831 458055 463174 439264 457694 478519 434914 426990 450854 456234 454028 450765 454643 539155 460251 464284 587587 194687 407250 466105 388350 450647 385955 421792 442444 445078 437019 450585 464443 504564 512586 696126 622297 185109 439345 446509 462231 471346 388551 429185 452372 483329 491602 523505 438712 460318 477848 539463 490168 455588 476149 278236 424207 397763 417005 453033 400938 397766 416335 489210 123541 416346 413240 509847 311734 429065 410836 471526 558045 451541 420869 472873 431167 447405 501730 488528 521869 271638 7213 421492 ] |
||||||||||||||||||||||||||||||
|
4.58 ms (2.76%) |
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 7213 123541 185109 194687 271638 278236 311734 327786 384551 385955 387175 388350 388551 392672 397209 397763 397766 400938 407250 409931 410836 413062 413240 416335 416346 417005 420869 421037 421189 421492 421792 424207 426920 426990 429065 429185 431167 434914 437019 438712 439146 439264 439345 441166 442444 444515 445078 446509 447405 450585 450647 450765 450854 451541 451691 452372 452596 453033 453831 454028 454643 455588 456209 456234 457694 458055 458098 458362 460251 460318 462231 463174 464284 464443 465411 466105 467223 467992 469036 469197 471346 471526 472587 472873 475606 476149 477848 478519 480242 483329 488528 488679 489210 490168 491602 501730 503082 503155 504564 506072 509847 509916 510495 512293 512586 512647 513675 521869 523505 538224 539155 539463 558045 558618 571736 587054 587587 622297 696126 809217 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс ласки"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс ласк"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.