Query Metrics
7
Database Queries
7
Different statements
360.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.66 ms (58.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step sister секс"
]
|
||||||||||||||||||||||||||||||
|
126.75 ms (35.18%) |
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 384938 395227 396883 397068 397555 399475 400668 406849 407182 412311 412717 413434 417097 417975 421338 427558 433352 433448 434887 437260 437303 441595 441691 441897 453191 457304 459214 460423 460894 464229 468625 468909 476397 476825 477319 483888 485756 485891 486192 490271 493476 493878 495409 495646 500043 501031 504282 510175 513321 513748 524266 528023 528107 532006 535944 537813 543457 543565 547392 550976 555965 559949 564801 570150 577944 579793 584562 588735 595967 598374 604726 610532 613227 617195 619368 625950 650076 650197 650648 662050 662183 680585 682625 696379 703289 706498 709739 710185 714580 718882 720175 736591 739675 742608 744251 748981 750308 754156 757370 761467 762310 763230 767448 770813 772017 778021 778975 780128 782753 784429 785276 785956 788050 791553 793013 805715 806131 809605 813585 ] |
||||||||||||||||||||||||||||||
|
14.62 ms (4.06%) |
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 476397 406849 397555 543457 780128 427558 441691 441897 485756 501031 535944 537813 504282 718882 696379 619368 791553 739675 703289 397068 437303 433352 495646 524266 528107 813585 579793 782753 744251 763230 709739 400668 399475 459214 453191 555965 564801 584562 809605 785276 742608 750308 714580 483888 550976 559949 625950 412311 543565 485891 532006 720175 662183 595967 793013 754156 757370 412717 493476 493878 617195 395227 441595 433448 476825 464229 513321 706498 710185 650076 680585 650648 662050 610532 613227 778021 784429 788050 806131 762310 767448 736591 772017 770813 778975 434887 437260 490271 495409 513748 477319 604726 748981 785956 396883 682625 805715 761467 486192 384938 407182 413434 417097 457304 460423 598374 460894 421338 468625 510175 417975 500043 528023 468909 570150 547392 570835 650197 577944 588735 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.64%) |
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 384938 395227 396883 397068 397555 399475 400668 406849 407182 412311 412717 413434 417097 417975 421338 427558 433352 433448 434887 437260 437303 441595 441691 441897 453191 457304 459214 460423 460894 464229 468625 468909 476397 476825 477319 483888 485756 485891 486192 490271 493476 493878 495409 495646 500043 501031 504282 510175 513321 513748 524266 528023 528107 532006 535944 537813 543457 543565 547392 550976 555965 559949 564801 570150 577944 579793 584562 588735 595967 598374 604726 610532 613227 617195 619368 625950 650076 650197 650648 662050 662183 680585 682625 696379 703289 706498 709739 710185 714580 718882 720175 736591 739675 742608 744251 748981 750308 754156 757370 761467 762310 763230 767448 770813 772017 778021 778975 780128 782753 784429 785276 785956 788050 791553 793013 805715 806131 809605 813585 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step sister fuck"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step sister секс"
]
|
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.