Query Metrics
7
Database Queries
7
Different statements
163.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.19 ms (83.19%) |
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 7389 12118 13428 33852 55266 69956 121057 183121 191361 303771 304611 305336 310708 366354 381945 383392 385759 386203 387559 389585 389609 390378 390924 391340 394212 394631 395809 396709 396743 397024 397204 398469 400515 400531 402771 402834 404402 408701 409163 409252 410428 411770 413035 413429 414756 417420 421732 422108 424965 429585 430728 431602 433030 433954 434430 434531 436449 437016 437172 437710 439452 440671 440687 440878 443002 444568 444705 445271 445288 446465 447166 448682 449158 449998 453227 454195 455098 455823 456174 458358 458432 459086 459826 461628 461969 463183 464634 465116 467063 473302 474116 474738 475629 476202 476518 477453 477645 480767 481959 482074 482260 482490 483828 490908 491609 491980 493057 493458 501509 509009 509215 509942 513124 513433 513712 525582 525877 527252 543993 786973 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (10.48%) |
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 183121 409252 443002 437016 445288 410428 55266 391340 408701 411770 455098 786973 477645 513124 396743 400531 396709 191361 458432 449158 409163 444568 447166 501509 513712 513433 385759 13428 413429 413035 482490 474116 459826 465116 476518 459086 397024 474738 305336 12118 389609 398469 476202 482260 461969 454195 467063 400515 433954 394631 437710 525877 491980 390378 461628 491609 449998 455823 404402 429585 389585 402771 543993 434531 304611 445271 527252 33852 69956 440671 458358 475629 431602 436449 473302 439452 402834 381945 303771 430728 483828 493057 482074 422108 463183 424965 477453 490908 509009 509215 421732 394212 397204 440878 481959 444705 446465 7389 417420 480767 448682 390924 386203 395809 366354 440687 456174 453227 433030 437172 434430 414756 383392 387559 464634 525582 493458 509942 121057 310708 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.66%) |
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 7389 12118 13428 33852 55266 69956 121057 183121 191361 303771 304611 305336 310708 366354 381945 383392 385759 386203 387559 389585 389609 390378 390924 391340 394212 394631 395809 396709 396743 397024 397204 398469 400515 400531 402771 402834 404402 408701 409163 409252 410428 411770 413035 413429 414756 417420 421732 422108 424965 429585 430728 431602 433030 433954 434430 434531 436449 437016 437172 437710 439452 440671 440687 440878 443002 444568 444705 445271 445288 446465 447166 448682 449158 449998 453227 454195 455098 455823 456174 458358 458432 459086 459826 461628 461969 463183 464634 465116 467063 473302 474116 474738 475629 476202 476518 477453 477645 480767 481959 482074 482260 482490 483828 490908 491609 491980 493057 493458 501509 509009 509215 509942 513124 513433 513712 525582 525877 527252 543993 786973 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"попку и в ротик"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп в ротик"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.03%) |
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.