Query Metrics
7
Database Queries
7
Different statements
176.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.35 ms (87.52%) |
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 397616 401233 401269 402364 403624 407710 413128 421712 429547 431345 432405 432631 435971 436682 439474 451801 455098 455834 464446 465861 466771 467239 469311 470595 471963 472972 474946 475298 475871 478146 479402 480953 482950 486057 489822 491976 492017 494323 495473 496218 496284 497394 500044 503933 505756 507410 508772 510535 512195 512207 516843 519967 520267 521978 522001 522117 522545 522587 522601 522994 524206 524763 525949 527373 528667 531602 533724 543209 543350 544284 546047 546718 546939 549064 550492 550639 551667 554302 557494 558723 559590 559603 559744 561438 561661 567686 568809 569570 569969 570171 571072 571871 572748 572808 575523 575740 576026 576311 578048 582199 582383 591403 596377 599801 613837 617681 618040 618069 618696 655730 658261 663440 665117 666436 671505 672677 689376 726603 793127 795934 ] |
||||||||||||||||||||||||||||||
|
12.78 ms (7.25%) |
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 474946 475871 520267 521978 489822 491976 522001 522587 503933 524206 432631 439474 455098 478146 455834 482950 497394 522994 516843 543209 572808 543350 544284 557494 559744 576311 546718 568809 658261 671505 558723 569570 578048 613837 596377 618040 618696 591403 617681 793127 795934 726603 618069 472972 466771 471963 479402 480953 403624 432405 413128 475298 470595 507410 494323 496218 495473 510535 397616 402364 401233 401269 429547 421712 435971 407710 436682 431345 549064 465861 469311 451801 464446 496284 500044 512195 524763 525949 527373 508772 519967 522117 528667 531602 522601 505756 512207 522545 533724 467239 486057 492017 546047 550639 561438 570171 575523 575740 576026 550492 561661 571072 582383 559590 559603 567686 569969 655730 666436 663440 665117 672677 689376 546939 551667 554302 571871 572748 582199 599801 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.53%) |
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 397616 401233 401269 402364 403624 407710 413128 421712 429547 431345 432405 432631 435971 436682 439474 451801 455098 455834 464446 465861 466771 467239 469311 470595 471963 472972 474946 475298 475871 478146 479402 480953 482950 486057 489822 491976 492017 494323 495473 496218 496284 497394 500044 503933 505756 507410 508772 510535 512195 512207 516843 519967 520267 521978 522001 522117 522545 522587 522601 522994 524206 524763 525949 527373 528667 531602 533724 543209 543350 544284 546047 546718 546939 549064 550492 550639 551667 554302 557494 558723 559590 559603 559744 561438 561661 567686 568809 569570 569969 570171 571072 571871 572748 572808 575523 575740 576026 576311 578048 582199 582383 591403 596377 599801 613837 617681 618040 618069 618696 655730 658261 663440 665117 666436 671505 672677 689376 726603 793127 795934 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck skirt"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс юбк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.84%) |
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.