Query Metrics
7
Database Queries
7
Different statements
141.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.05 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.29 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ÐüðÁð║Ðü Ðü ðÀð░ð│ð¥ÐÇðÁð╗Ðïð╝ð© ðÂðÁð¢ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.11 ms |
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 513593 537649 553478 559008 561297 562964 602356 509272 567311 460258 516328 522017 573361 585384 609794 551939 493361 521028 527986 559076 593032 577488 561380 613823 474896 471125 553927 571723 543553 565626 612699 524114 467993 565095 600411 595226 495224 491353 516317 481964 580094 624400 519367 556426 443374 537268 479142 511278 619508 475111 513342 518153 581433 527062 527989 606533 600736 496802 460281 516332 528384 484456 483709 426405 571827 551130 671893 516335 460738 623334 582639 561381 590515 676591 613463 517326 583913 448732 518131 516661 635783 517301 442363 537251 504085 522556 ] |
||||||||||||||||||||||||||||||
| 4 | 2.82 ms |
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 426405 442363 443374 448732 460258 460281 460738 467993 471125 474896 475111 479142 481964 483709 484456 491353 493361 495224 496802 504085 509272 511278 513342 513593 516317 516328 516332 516335 516661 517301 517326 518131 518153 519367 521028 522017 522556 524114 527062 527986 527989 528384 537251 537268 537649 543553 551130 551939 553478 553927 556426 559008 561297 561380 561381 562964 565095 565626 567311 571723 571827 573361 577488 580094 581433 582639 583913 585384 590515 593032 595226 600411 600736 602356 606533 609794 612699 613463 613823 619508 623334 624400 635783 671893 676591 ] |
||||||||||||||||||||||||||||||
| 5 | 115.84 ms |
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 426405 442363 443374 448732 460258 460281 460738 467993 471125 474896 475111 479142 481964 483709 484456 491353 493361 495224 496802 504085 509272 511278 513342 513593 516317 516328 516332 516335 516661 517301 517326 518131 518153 519367 521028 522017 522556 524114 527062 527986 527989 528384 537251 537268 537649 543553 551130 551939 553478 553927 556426 559008 561297 561380 561381 562964 565095 565626 567311 571723 571827 573361 577488 580094 581433 582639 583913 585384 590515 593032 595226 600411 600736 602356 606533 609794 612699 613463 613823 619508 623334 624400 635783 671893 676591 ] |
||||||||||||||||||||||||||||||
| 6 | 1.91 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс загорелые жен"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.59 ms |
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.