Query Metrics
7
Database Queries
7
Different statements
248.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.68 ms (83.68%) |
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 178441 383159 396294 401047 403716 410841 415507 420159 423880 424531 431496 439508 440851 442431 443958 447542 456649 456752 460447 462533 468899 477179 478157 479389 479959 480328 487272 491501 491669 491721 506112 510658 511982 513276 520379 522590 522811 524180 527623 573780 574571 574896 575478 575483 575754 576054 576076 576351 581928 592571 605778 606556 609672 613172 613333 619870 619878 620670 623691 624616 625013 625434 628326 630528 634305 637129 639934 640033 649571 660048 661896 666420 677098 678698 682336 683256 691414 692750 696047 701501 706899 708350 709445 711590 714026 714117 717834 724253 725687 726705 727828 732119 732423 733857 740157 741219 743117 743380 745386 750816 752058 770148 771527 774994 774995 775708 775781 776164 784261 788416 790895 793567 796938 799595 803292 803460 805169 806218 810678 ] |
||||||||||||||||||||||||||||||
|
31.04 ms (12.51%) |
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 576054 581928 660048 666420 678698 682336 691414 692750 708350 649571 661896 701501 709445 714117 677098 683256 696047 573780 574571 574896 575478 575483 575754 576076 576351 619878 628326 637129 592571 613172 620670 625013 639934 606556 623691 624616 605778 613333 625434 630528 634305 775708 810678 774994 784261 790895 803292 725687 726705 799595 805169 727828 733857 741219 743380 771527 732119 743117 750816 752058 724357 732423 740157 745386 770148 724253 609672 619870 640033 706899 711590 714026 717834 774995 775781 776164 788416 793567 796938 803460 806218 401047 415507 420159 431496 439508 456752 396294 440851 468899 479389 423880 424531 443958 447542 456649 462533 479959 480328 178441 383159 403716 410841 477179 442431 460447 478157 510658 511982 513276 520379 522590 522811 524180 527623 487272 491501 491669 491721 506112 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.29%) |
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 178441 383159 396294 401047 403716 410841 415507 420159 423880 424531 431496 439508 440851 442431 443958 447542 456649 456752 460447 462533 468899 477179 478157 479389 479959 480328 487272 491501 491669 491721 506112 510658 511982 513276 520379 522590 522811 524180 527623 573780 574571 574896 575478 575483 575754 576054 576076 576351 581928 592571 605778 606556 609672 613172 613333 619870 619878 620670 623691 624616 625013 625434 628326 630528 634305 637129 639934 640033 649571 660048 661896 666420 677098 678698 682336 683256 691414 692750 696047 701501 706899 708350 709445 711590 714026 714117 717834 724253 725687 726705 727828 732119 732423 733857 740157 741219 743117 743380 745386 750816 752058 770148 771527 774994 774995 775708 775781 776164 784261 788416 790895 793567 796938 799595 803292 803460 805169 806218 810678 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm porn"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм porn"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.58%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.20 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм porn"
]
|
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.