Query Metrics
7
Database Queries
7
Different statements
207.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.70 ms (81.71%) |
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 425452 426096 429069 429867 437088 438431 443909 456226 459934 464195 465326 467387 482775 486791 489015 493225 495669 498963 499800 501841 502064 502607 503739 504516 505548 507661 508938 510855 512077 513502 516277 518888 519104 519948 520176 520507 520635 522342 522469 522475 524062 524496 525428 526125 526199 527207 529338 532560 536675 537870 538971 541393 545968 549170 549335 549864 551612 551816 555950 557052 557679 559377 560902 562346 563228 567127 570978 571976 574511 575705 576386 576419 576649 576721 577369 578197 578661 578829 581066 582282 584004 584667 584673 584735 585332 587059 588228 590345 590398 592038 595699 596025 596748 598355 598899 599002 599621 599711 601338 602000 602439 604667 605414 607385 609915 610087 611902 614095 616460 618460 618715 618868 618895 619201 619411 623291 627446 661989 663514 672954 ] |
||||||||||||||||||||||||||||||
|
26.03 ms (12.54%) |
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 576649 585332 510855 437088 522342 519948 522469 584735 563228 584004 549170 602439 499800 520507 526125 512077 616460 618460 486791 464195 467387 537870 502607 536675 501841 522475 526199 549335 576386 581066 560902 576721 575705 584667 584673 578197 610087 614095 609915 611902 619411 592038 618715 429069 438431 513502 443909 465326 504516 498963 516277 502064 505548 508938 532560 541393 549864 570978 559377 545968 551612 557052 590398 623291 598899 599621 598355 627446 456226 426096 493225 459934 495669 525428 520176 524062 524496 538971 518888 562346 574511 576419 577369 588228 618868 482775 503739 529338 519104 489015 555950 557679 551816 663514 672954 661989 571976 578661 619201 601338 605414 596025 596748 604667 607385 618895 602000 429867 527207 507661 520635 567127 582282 578829 587059 590345 595699 599002 599711 425452 ] |
||||||||||||||||||||||||||||||
|
4.85 ms (2.34%) |
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 425452 426096 429069 429867 437088 438431 443909 456226 459934 464195 465326 467387 482775 486791 489015 493225 495669 498963 499800 501841 502064 502607 503739 504516 505548 507661 508938 510855 512077 513502 516277 518888 519104 519948 520176 520507 520635 522342 522469 522475 524062 524496 525428 526125 526199 527207 529338 532560 536675 537870 538971 541393 545968 549170 549335 549864 551612 551816 555950 557052 557679 559377 560902 562346 563228 567127 570978 571976 574511 575705 576386 576419 576649 576721 577369 578197 578661 578829 581066 582282 584004 584667 584673 584735 585332 587059 588228 590345 590398 592038 595699 596025 596748 598355 598899 599002 599621 599711 601338 602000 602439 604667 605414 607385 609915 610087 611902 614095 616460 618460 618715 618868 618895 619201 619411 623291 627446 661989 663514 672954 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"finger fuck"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"палец секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.73%) |
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.