Query Metrics
7
Database Queries
7
Different statements
236.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.92 ms (88.64%) |
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 95855 390320 390381 391601 395354 396565 397385 412688 412872 418069 418368 422303 423797 424715 426306 427009 427265 427515 427907 428467 431604 435356 435583 439023 442627 446314 446864 448826 449277 452764 453727 453948 454459 455019 457231 458077 458869 460369 463372 464408 464895 467577 467900 467970 468521 469426 470882 471472 471967 472547 474933 476490 476780 478143 478359 479014 479966 481088 482041 483168 483415 484925 485919 487633 488855 494106 494180 496236 496896 500204 506240 508881 509120 511653 513257 519181 519447 519772 520089 521345 522251 522259 522683 525312 526625 530146 536652 542090 543318 544037 547796 549770 555002 556518 563744 564545 564988 568727 570971 571217 571335 572194 573267 575215 576374 577243 577330 579957 581036 590355 592785 611609 617360 667532 667875 668886 755208 781400 795531 813112 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (7.21%) |
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 520089 483415 488855 506240 511653 525312 496236 508881 513257 522251 522259 522683 485919 494106 494180 496896 509120 519447 519772 526625 95855 395354 397385 422303 418368 427907 442627 454459 468521 448826 453948 467577 470882 471967 484925 453727 467970 471472 476780 478143 487633 521345 500204 536652 519181 530146 479014 483168 542090 543318 556518 563744 570971 572194 577330 579957 547796 564988 568727 581036 544037 549770 555002 564545 571217 571335 573267 575215 577243 668886 667875 667532 576374 617360 590355 592785 781400 795531 755208 611609 813112 391601 396565 412688 423797 452764 457231 464408 464895 469426 476490 478359 427009 428467 431604 449277 460369 467900 474933 482041 390381 427265 435356 439023 446314 458077 472547 479966 481088 390320 412872 418069 426306 427515 435583 446864 455019 458869 463372 424715 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.05%) |
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 95855 390320 390381 391601 395354 396565 397385 412688 412872 418069 418368 422303 423797 424715 426306 427009 427265 427515 427907 428467 431604 435356 435583 439023 442627 446314 446864 448826 449277 452764 453727 453948 454459 455019 457231 458077 458869 460369 463372 464408 464895 467577 467900 467970 468521 469426 470882 471472 471967 472547 474933 476490 476780 478143 478359 479014 479966 481088 482041 483168 483415 484925 485919 487633 488855 494106 494180 496236 496896 500204 506240 508881 509120 511653 513257 519181 519447 519772 520089 521345 522251 522259 522683 525312 526625 530146 536652 542090 543318 544037 547796 549770 555002 556518 563744 564545 564988 568727 570971 571217 571335 572194 573267 575215 576374 577243 577330 579957 581036 590355 592785 611609 617360 667532 667875 668886 755208 781400 795531 813112 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стороны"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сторон"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.70%) |
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.