Query Metrics
7
Database Queries
7
Different statements
115.51 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.56 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde hard sex"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.73 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 440339 421201 415576 418484 448808 590620 446877 452297 446007 439566 452300 455866 441195 460619 565197 454061 513954 505639 509024 468009 619396 499354 504304 191179 464336 464977 529801 553673 524042 793608 434456 407895 397906 471678 466369 426195 506827 505623 579546 455041 415005 424259 481361 438045 421580 446203 457630 455228 527923 584752 445681 462606 463082 478966 601150 481463 560195 512973 456812 431913 444963 630187 428640 518241 525245 459535 503405 457162 497409 618525 416989 444606 631504 462450 600069 497661 587056 499863 441024 524427 660306 516214 551299 653244 572886 625239 598505 489438 ] |
||||||||||||||||||||||||||||||
| 4 | 2.51 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 191179 397906 407895 415005 415576 416989 418484 421201 421580 424259 426195 428640 431913 434456 438045 439566 440339 441024 441195 444606 444963 445681 446007 446203 446877 448808 452297 452300 454061 455041 455228 455866 456812 457162 457630 459535 460619 462450 462606 463082 464336 464977 466369 468009 471678 478966 481361 481463 489438 497409 497661 499354 499863 503405 504304 505623 505639 506827 509024 512973 513954 516214 518241 524042 524427 525245 527923 529801 551299 553673 560195 565197 572886 579546 584752 587056 590620 598505 600069 601150 618525 619396 625239 630187 631504 653244 660306 793608 ] |
||||||||||||||||||||||||||||||
| 5 | 91.85 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 191179 397906 407895 415005 415576 416989 418484 421201 421580 424259 426195 428640 431913 434456 438045 439566 440339 441024 441195 444606 444963 445681 446007 446203 446877 448808 452297 452300 454061 455041 455228 455866 456812 457162 457630 459535 460619 462450 462606 463082 464336 464977 466369 468009 471678 478966 481361 481463 489438 497409 497661 499354 499863 503405 504304 505623 505639 506827 509024 512973 513954 516214 518241 524042 524427 525245 527923 529801 551299 553673 560195 565197 572886 579546 584752 587056 590620 598505 600069 601150 618525 619396 625239 630187 631504 653244 660306 793608 ] |
||||||||||||||||||||||||||||||
| 6 | 1.48 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая hard секс"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.37 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая hard секс"
]
|
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.