Query Metrics
7
Database Queries
7
Different statements
183.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.75 ms (87.40%) |
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 102271 285231 290847 339821 379777 383392 386596 390045 390218 393754 402676 404522 404772 407436 410602 415859 416032 416561 416624 418632 419217 421298 424427 425968 426154 426701 429905 430345 430474 430837 430838 432120 432274 433002 434044 435487 436829 437089 437867 439325 441985 443241 443732 445596 448176 448211 450268 452768 453077 453201 454089 454186 456034 457453 459309 460334 462724 463456 463769 464379 467886 467952 469167 470058 471162 473533 474402 474795 474840 477071 478039 478678 482332 484918 486757 490518 490577 493203 493897 495689 497430 499914 500398 501836 503870 504367 504731 506239 506369 508757 511472 514155 516536 517445 519209 520146 523170 544011 549874 552439 557468 558033 564856 565950 568064 570717 577068 583996 590730 598820 613851 620120 624975 669647 699682 710871 735057 760739 809923 814265 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (8.11%) |
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 484918 486757 490518 497430 504731 506239 493897 499914 501836 504367 506369 520146 393754 290847 379777 339821 390045 404522 415859 416624 418632 432120 416561 421298 425968 430345 432274 433002 441985 435487 434044 437867 443241 814265 448176 453077 454089 454186 473533 474840 478039 478678 456034 470058 471162 482332 493203 453201 467952 477071 495689 500398 508757 514155 523170 519209 490577 549874 565950 568064 557468 544011 558033 583996 669647 710871 552439 564856 570717 577068 590730 613851 620120 598820 624975 760739 809923 735057 699682 390218 402676 407436 410602 426701 430838 463456 463769 467886 469167 102271 404772 429905 436829 474795 285231 386596 424427 426154 430474 450268 452768 460334 464379 474402 383392 419217 430837 437089 445596 448211 457453 462724 416032 439325 443732 459309 503870 511472 516536 517445 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.27%) |
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 102271 285231 290847 339821 379777 383392 386596 390045 390218 393754 402676 404522 404772 407436 410602 415859 416032 416561 416624 418632 419217 421298 424427 425968 426154 426701 429905 430345 430474 430837 430838 432120 432274 433002 434044 435487 436829 437089 437867 439325 441985 443241 443732 445596 448176 448211 450268 452768 453077 453201 454089 454186 456034 457453 459309 460334 462724 463456 463769 464379 467886 467952 469167 470058 471162 473533 474402 474795 474840 477071 478039 478678 482332 484918 486757 490518 490577 493203 493897 495689 497430 499914 500398 501836 503870 504367 504731 506239 506369 508757 511472 514155 516536 517445 519209 520146 523170 544011 549874 552439 557468 558033 564856 565950 568064 570717 577068 583996 590730 598820 613851 620120 624975 669647 699682 710871 735057 760739 809923 814265 ] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с разными"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"разн"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.