Query Metrics
7
Database Queries
7
Different statements
131.95 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.73 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.24 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex surprise"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.55 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 502663 491707 453732 538251 518774 579869 557544 591194 644762 465256 472974 460590 602002 591487 500420 540612 593778 623376 416255 567363 521186 572697 637402 590561 492913 409024 621657 560209 605663 491508 491664 517464 527931 561131 593808 484977 413904 524693 624840 593641 623792 452566 582062 593831 520744 562475 418340 593639 596497 535684 579876 455351 532029 690149 442501 555681 505012 416233 586009 523813 479816 518268 540807 540657 628404 486529 540483 613177 502794 557064 559948 598653 583913 534021 583371 624930 614991 607261 615574 603885 621655 593574 622187 486665 483223 429084 ] |
||||||||||||||||||||||||||||||
| 4 | 2.60 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 409024 413904 416233 416255 418340 429084 442501 452566 453732 455351 460590 465256 472974 479816 483223 484977 486529 486665 491508 491664 491707 492913 500420 502663 502794 505012 517464 518268 518774 520744 521186 523813 524693 527931 532029 534021 535684 538251 540483 540612 540657 540807 555681 557064 557544 559948 560209 561131 562475 567363 572697 579869 579876 582062 583371 583913 586009 590561 591194 591487 593574 593639 593641 593778 593808 593831 596497 598653 602002 603885 605663 607261 613177 614991 615574 621655 621657 622187 623376 623792 624840 624930 628404 637402 644762 690149 ] |
||||||||||||||||||||||||||||||
| 5 | 106.14 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 409024 413904 416233 416255 418340 429084 442501 452566 453732 455351 460590 465256 472974 479816 483223 484977 486529 486665 491508 491664 491707 492913 500420 502663 502794 505012 517464 518268 518774 520744 521186 523813 524693 527931 532029 534021 535684 538251 540483 540612 540657 540807 555681 557064 557544 559948 560209 561131 562475 567363 572697 579869 579876 582062 583371 583913 586009 590561 591194 591487 593574 593639 593641 593778 593808 593831 596497 598653 602002 603885 605663 607261 613177 614991 615574 621655 621657 622187 623376 623792 624840 624930 628404 637402 644762 690149 ] |
||||||||||||||||||||||||||||||
| 6 | 1.85 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс surprise"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.85 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс surprise"
]
|
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.