Query Metrics
7
Database Queries
7
Different statements
172.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.91 ms (78.84%) |
1 |
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 22984 411046 415095 425682 426482 427593 427654 428382 428392 430572 437416 442384 449688 450508 454535 455343 457643 461149 467066 470568 473259 474863 475272 475280 477236 478425 480387 482539 486962 487519 489626 489809 491583 491746 494677 504602 511427 512652 512693 515786 517028 517626 518583 519095 520389 521168 523950 523954 523974 525984 526947 528283 532441 537310 541887 543420 543614 549362 551190 551262 552887 558469 565948 566075 566686 567648 567822 568306 568989 569518 569540 571828 572037 572551 572841 578449 581118 581402 582521 584049 585397 587046 590689 591181 598515 599273 604551 605673 605688 605703 610559 610635 610656 617486 620163 621651 623334 635723 637087 643028 649888 649893 651589 664800 670263 680815 701520 702866 730372 744912 749106 756113 760009 760736 772807 778307 805149 810299 815598 822598 ] |
||||||||||||||||||||||||||||||
|
27.04 ms (15.68%) |
1 |
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 578449 610656 621651 635723 598515 605673 620163 805149 760009 730372 411046 425682 487519 525984 430572 457643 567822 572037 582521 543420 587046 599273 643028 670263 517028 649888 478425 504602 520389 537310 552887 566075 581118 566686 569518 569540 572841 558469 760736 523954 489809 515786 523974 450508 480387 584049 426482 454535 491583 494677 651589 518583 623334 649893 701520 617486 22984 427593 415095 437416 815598 470568 521168 526947 528283 489626 541887 572551 610635 605688 637087 810299 744912 756113 702866 442384 427654 455343 428382 473259 512652 486962 511427 532441 571828 568989 604551 610559 491746 605703 461149 778307 474863 475272 449688 482539 551262 567648 565948 568306 680815 585397 551190 590689 512693 475280 543614 591181 517626 822598 519095 549362 772807 467066 477236 428392 664800 581402 749106 523950 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.37%) |
1 |
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 22984 411046 415095 425682 426482 427593 427654 428382 428392 430572 437416 442384 449688 450508 454535 455343 457643 461149 467066 470568 473259 474863 475272 475280 477236 478425 480387 482539 486962 487519 489626 489809 491583 491746 494677 504602 511427 512652 512693 515786 517028 517626 518583 519095 520389 521168 523950 523954 523974 525984 526947 528283 532441 537310 541887 543420 543614 549362 551190 551262 552887 558469 565948 566075 566686 567648 567822 568306 568989 569518 569540 571828 572037 572551 572841 578449 581118 581402 582521 584049 585397 587046 590689 591181 598515 599273 604551 605673 605688 605703 610559 610635 610656 617486 620163 621651 623334 635723 637087 643028 649888 649893 651589 664800 670263 680815 701520 702866 730372 744912 749106 756113 760009 760736 772807 778307 805149 810299 815598 822598 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toilet public"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.86%) |
1 |
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.