Query Metrics
7
Database Queries
7
Different statements
119.45 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.13 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.72 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"руское порно больно"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.27 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 473974 437204 516136 521871 525391 489544 519436 547838 577816 573917 614689 427437 458899 471330 482081 436437 428716 448846 510456 484423 540721 563493 448562 423979 457130 432843 495937 552978 558566 560845 546465 468910 430374 455096 441168 461454 500978 495259 524712 528262 560396 560858 447412 487325 597501 598067 456452 454238 447615 473781 427166 513061 489097 505614 655087 653267 598464 598510 451497 588801 637243 595891 456362 542218 484581 655615 604289 547620 467508 652907 651938 598524 599404 619965 601976 518521 484372 654552 617006 601906 563446 634230 599512 622778 657438 601314 611900 610695 649185 ] |
||||||||||||||||||||||||||||||
| 4 | 2.25 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 423979 427166 427437 428716 430374 432843 436437 437204 441168 447412 447615 448562 448846 451497 454238 455096 456362 456452 457130 458899 461454 467508 468910 471330 473781 473974 482081 484372 484423 484581 487325 489097 489544 495259 495937 500978 505614 510456 513061 516136 518521 519436 521871 524712 525391 528262 540721 542218 546465 547620 547838 552978 558566 560396 560845 560858 563446 563493 573917 577816 588801 595891 597501 598067 598464 598510 598524 599404 599512 601314 601906 601976 604289 610695 611900 614689 617006 619965 622778 634230 637243 649185 651938 652907 653267 654552 655087 655615 657438 ] |
||||||||||||||||||||||||||||||
| 5 | 91.78 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 423979 427166 427437 428716 430374 432843 436437 437204 441168 447412 447615 448562 448846 451497 454238 455096 456362 456452 457130 458899 461454 467508 468910 471330 473781 473974 482081 484372 484423 484581 487325 489097 489544 495259 495937 500978 505614 510456 513061 516136 518521 519436 521871 524712 525391 528262 540721 542218 546465 547620 547838 552978 558566 560396 560845 560858 563446 563493 573917 577816 588801 595891 597501 598067 598464 598510 598524 599404 599512 601314 601906 601976 604289 610695 611900 614689 617006 619965 622778 634230 637243 649185 651938 652907 653267 654552 655087 655615 657438 ] |
||||||||||||||||||||||||||||||
| 6 | 1.75 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск порн крича вперв"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.56 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.