Query Metrics
7
Database Queries
7
Different statements
148.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.84 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 | 21.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 463864 452058 464336 456981 417883 524208 494620 558626 551137 528580 508769 455847 468754 476360 480439 524952 420190 519093 430504 429943 549992 500551 406308 417889 426459 500312 448987 417344 457963 446198 510463 460706 451563 520766 586651 523816 434000 414357 557526 416098 506143 603252 417482 467632 449595 548577 468586 478527 603875 434001 425351 575197 480429 451983 508547 418363 457160 562796 499817 420925 495752 414075 468035 494345 517184 449869 516820 514113 481675 525226 414374 443636 417801 434712 489328 541833 495273 448839 494617 552969 445641 542195 463842 469534 497452 529794 496033 495217 ] |
||||||||||||||||||||||||||||||
| 4 | 3.22 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 406308 414075 414357 414374 416098 417344 417482 417801 417883 417889 418363 420190 420925 425351 426459 429943 430504 434000 434001 434712 443636 445641 446198 448839 448987 449595 449869 451563 451983 452058 455847 456981 457160 457963 460706 463842 463864 464336 467632 468035 468586 468754 469534 476360 478527 480429 480439 481675 489328 494345 494617 494620 495217 495273 495752 496033 497452 499817 500312 500551 506143 508547 508769 510463 514113 516820 517184 519093 520766 523816 524208 524952 525226 528580 529794 541833 542195 548577 549992 551137 552969 557526 558626 562796 575197 586651 603252 603875 ] |
||||||||||||||||||||||||||||||
| 5 | 117.06 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 406308 414075 414357 414374 416098 417344 417482 417801 417883 417889 418363 420190 420925 425351 426459 429943 430504 434000 434001 434712 443636 445641 446198 448839 448987 449595 449869 451563 451983 452058 455847 456981 457160 457963 460706 463842 463864 464336 467632 468035 468586 468754 469534 476360 478527 480429 480439 481675 489328 494345 494617 494620 495217 495273 495752 496033 497452 499817 500312 500551 506143 508547 508769 510463 514113 516820 517184 519093 520766 523816 524208 524952 525226 528580 529794 541833 542195 548577 549992 551137 552969 557526 558626 562796 575197 586651 603252 603875 ] |
||||||||||||||||||||||||||||||
| 6 | 1.78 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс чернокожий"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 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.