Query Metrics
7
Database Queries
7
Different statements
432.02 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.71 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 211.15 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"куни сто"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.96 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 543810 493381 666486 485985 509697 510559 521085 552340 626847 520174 512739 416405 486536 579648 566074 559921 487001 518588 627744 509591 606769 466148 545701 553059 417775 521156 528396 519231 523496 528022 561369 568053 543565 565167 383597 474425 563198 547072 524948 487918 517073 613839 481674 507642 492799 584709 672682 488751 492279 526351 586519 415776 528794 580300 522926 567134 447890 580256 526103 565471 689702 507169 507213 465525 581112 469539 555821 516760 621348 609085 524508 577350 521412 444606 559183 467088 494617 541871 535344 556741 494764 602569 590866 523822 434601 ] |
||||||||||||||||||||||||||||||
| 4 | 2.88 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 383597 415776 416405 417775 434601 444606 447890 465525 466148 467088 469539 474425 481674 485985 486536 487001 487918 488751 492279 492799 493381 494617 494764 507169 507213 507642 509591 509697 510559 512739 516760 517073 518588 519231 520174 521085 521156 521412 522926 523496 523822 524508 524948 526103 526351 528022 528396 528794 535344 541871 543565 543810 545701 547072 552340 553059 555821 556741 559183 559921 561369 563198 565167 565471 566074 567134 568053 577350 579648 580256 580300 581112 584709 586519 590866 602569 606769 609085 613839 621348 626847 627744 666486 672682 689702 ] |
||||||||||||||||||||||||||||||
| 5 | 199.64 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 383597 415776 416405 417775 434601 444606 447890 465525 466148 467088 469539 474425 481674 485985 486536 487001 487918 488751 492279 492799 493381 494617 494764 507169 507213 507642 509591 509697 510559 512739 516760 517073 518588 519231 520174 521085 521156 521412 522926 523496 523822 524508 524948 526103 526351 528022 528396 528794 535344 541871 543565 543810 545701 547072 552340 553059 555821 556741 559183 559921 561369 563198 565167 565471 566074 567134 568053 577350 579648 580256 580300 581112 584709 586519 590866 602569 606769 609085 613839 621348 626847 627744 666486 672682 689702 ] |
||||||||||||||||||||||||||||||
| 6 | 2.08 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс сто"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.60 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.