Query Metrics
7
Database Queries
7
Different statements
128.43 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.57 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.95 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex shower brother"
]
|
||||||||||||||||||||||||||||||
| 3 | 10.78 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 658844 445497 724321 563830 448699 615769 452454 426494 431761 471182 420495 823581 580082 819505 776089 792752 536913 730116 618738 434676 458713 720868 419354 447594 80821 521153 636087 702631 532049 689525 770775 403028 282649 532006 495432 492448 483320 516682 445892 658765 537900 409053 532359 553062 548259 421655 453234 548263 414972 385701 523475 470871 504725 559949 490566 476329 431501 485264 417368 398678 425513 510007 499021 447574 804833 455574 526518 605758 430394 442970 472774 535940 519661 437996 625436 527066 427327 511514 500911 421118 523496 455660 425336 414979 526805 519903 425844 523492 524187 ] |
||||||||||||||||||||||||||||||
| 4 | 2.97 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 80821 282649 385701 398678 403028 409053 414972 414979 417368 419354 420495 421118 421655 425336 425513 425844 426494 427327 430394 431501 431761 434676 437996 442970 445497 445892 447574 447594 448699 452454 453234 455574 455660 458713 470871 471182 472774 476329 483320 485264 490566 492448 495432 499021 500911 504725 510007 511514 516682 519661 519903 521153 523475 523492 523496 524187 526518 526805 527066 532006 532049 532359 535940 536913 537900 548259 548263 553062 559949 563830 580082 605758 615769 618738 625436 636087 658765 658844 689525 702631 720868 724321 730116 770775 776089 792752 804833 819505 823581 ] |
||||||||||||||||||||||||||||||
| 5 | 107.69 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 80821 282649 385701 398678 403028 409053 414972 414979 417368 419354 420495 421118 421655 425336 425513 425844 426494 427327 430394 431501 431761 434676 437996 442970 445497 445892 447574 447594 448699 452454 453234 455574 455660 458713 470871 471182 472774 476329 483320 485264 490566 492448 495432 499021 500911 504725 510007 511514 516682 519661 519903 521153 523475 523492 523496 524187 526518 526805 527066 532006 532049 532359 535940 536913 537900 548259 548263 553062 559949 563830 580082 605758 615769 618738 625436 636087 658765 658844 689525 702631 720868 724321 730116 770775 776089 792752 804833 819505 823581 ] |
||||||||||||||||||||||||||||||
| 6 | 1.83 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс shower brother"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.64 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс shower brother"
]
|
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.