Query Metrics
7
Database Queries
7
Different statements
365.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.17 ms (58.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал фистинг домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
126.52 ms (34.59%) |
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 151179 389794 396071 412830 412852 416527 416531 416680 416690 416746 421993 428171 431439 432929 441203 441853 446031 448115 449377 450889 466427 471455 474596 480502 485527 487200 490232 493486 493763 500341 500734 508891 514235 514744 514879 515974 520797 529714 530368 531844 531856 531888 534536 536393 540945 541277 541317 541392 541421 545395 545428 545439 545453 548153 562784 564293 573207 575589 575859 576951 581098 583713 586999 594491 595847 609889 613032 628105 634746 658787 658816 660047 662856 664166 680252 695559 703574 711615 713508 717514 717520 717542 728215 740922 740932 744047 745082 745092 745111 749221 749243 749255 751727 752612 752623 752630 752642 752651 752666 752669 752711 759370 761752 766943 770210 770225 770269 770821 770864 778172 778230 782844 784775 786850 791885 796905 806938 809371 811771 827489 ] |
||||||||||||||||||||||||||||||
|
19.42 ms (5.31%) |
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 752666 770210 752651 759370 428171 548153 541277 520797 515974 531856 466427 575859 703574 717542 662856 717520 680252 613032 782844 786850 811771 784775 740932 749221 766943 770864 728215 151179 594491 575589 573207 446031 485527 508891 416680 432929 581098 595847 770225 441203 450889 396071 412852 431439 449377 493763 531844 541392 545395 660047 711615 628105 740922 806938 761752 751727 770269 749243 412830 441853 536393 514235 500734 500341 634746 471455 487200 389794 416746 474596 770821 717514 421993 416527 416531 416690 827489 480502 448115 534536 514879 529714 530368 493486 545453 541421 540945 541317 658787 658816 586999 778172 778230 791885 744047 745092 745111 752612 752669 752711 745082 752623 749255 752630 752642 609889 809371 562784 545439 514744 545428 576951 490232 531888 564293 583713 695559 664166 713508 796905 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.59%) |
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 151179 389794 396071 412830 412852 416527 416531 416680 416690 416746 421993 428171 431439 432929 441203 441853 446031 448115 449377 450889 466427 471455 474596 480502 485527 487200 490232 493486 493763 500341 500734 508891 514235 514744 514879 515974 520797 529714 530368 531844 531856 531888 534536 536393 540945 541277 541317 541392 541421 545395 545428 545439 545453 548153 562784 564293 573207 575589 575859 576951 581098 583713 586999 594491 595847 609889 613032 628105 634746 658787 658816 660047 662856 664166 680252 695559 703574 711615 713508 717514 717520 717542 728215 740922 740932 744047 745082 745092 745111 749221 749243 749255 751727 752612 752623 752630 752642 752651 752666 752669 752711 759370 761752 766943 770210 770225 770269 770821 770864 778172 778230 782844 784775 786850 791885 796905 806938 809371 811771 827489 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал фистинг домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал фистинг дома"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.