Query Metrics
7
Database Queries
7
Different statements
143.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.69 ms (85.53%) |
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 907 2926 6982 34087 34706 61625 81526 204849 207824 226412 230974 310133 311697 315762 337234 341118 381964 382436 382665 383051 383646 385220 385368 387648 387675 387835 388195 388417 389059 389213 389911 390022 390249 390856 391266 391662 391774 392481 396026 397132 397663 398043 398399 398593 398948 399003 399009 399994 400406 400908 401589 402024 402619 405972 413196 414005 414146 414736 418562 438682 441183 443144 444512 447733 448702 453090 453859 454797 460931 462810 466338 468327 477925 478028 479374 482947 493820 496235 510354 518186 521808 529760 530968 531546 534628 538580 539960 539965 541175 543056 545244 546649 547898 549275 551775 551794 556140 574338 577282 580844 584140 645538 645728 648931 650068 650524 653974 662125 667803 673312 674900 677510 687381 691423 705017 705347 708614 708747 718950 814169 ] |
||||||||||||||||||||||||||||||
|
12.16 ms (8.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 466338 907 315762 337234 382665 388417 398593 399003 401589 413196 441183 414736 518186 482947 510354 383051 383646 385368 385220 226412 207824 204849 230974 392481 391662 391774 310133 311697 341118 381964 382436 34087 61625 34706 6982 81526 2926 389213 389059 389911 387675 387648 388195 390022 390249 390856 391266 387835 396026 397132 398399 398043 397663 399994 400406 400908 399009 398948 402619 402024 405972 418562 444512 438682 414005 414146 443144 814169 447733 453859 454797 460931 453090 448702 462810 477925 478028 493820 496235 530968 539965 531546 534628 538580 539960 521808 529760 468327 479374 546649 549275 551794 577282 580844 584140 543056 547898 551775 541175 545244 556140 574338 650068 650524 653974 662125 673312 674900 677510 687381 708614 645728 667803 691423 705017 705347 708747 718950 645538 648931 ] |
||||||||||||||||||||||||||||||
|
2.37 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 907 2926 6982 34087 34706 61625 81526 204849 207824 226412 230974 310133 311697 315762 337234 341118 381964 382436 382665 383051 383646 385220 385368 387648 387675 387835 388195 388417 389059 389213 389911 390022 390249 390856 391266 391662 391774 392481 396026 397132 397663 398043 398399 398593 398948 399003 399009 399994 400406 400908 401589 402024 402619 405972 413196 414005 414146 414736 418562 438682 441183 443144 444512 447733 448702 453090 453859 454797 460931 462810 466338 468327 477925 478028 479374 482947 493820 496235 510354 518186 521808 529760 530968 531546 534628 538580 539960 539965 541175 543056 545244 546649 547898 549275 551775 551794 556140 574338 577282 580844 584140 645538 645728 648931 650068 650524 653974 662125 667803 673312 674900 677510 687381 691423 705017 705347 708614 708747 718950 814169 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"теле"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тел"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.80%) |
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.