Query Metrics
7
Database Queries
7
Different statements
192.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.45 ms (82.27%) |
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 383387 386016 400461 401840 419382 421536 426518 428672 446481 451570 453066 453082 456859 457290 457332 459159 459161 463229 464491 465905 470532 472358 473245 473362 473364 474538 474566 486390 486699 487999 490843 490868 494687 495402 495608 496298 504964 512823 512830 514704 514733 516313 522395 523293 526185 530312 533320 533340 533628 534789 537848 537969 539106 539112 539116 541891 543260 543606 543756 545408 546857 549859 550846 551055 552251 553916 559200 560083 562367 562371 566347 569021 569202 572736 575787 579138 579372 582476 585124 590188 591329 595735 598452 598515 603270 606566 609954 612402 619457 619822 623231 624789 629886 629892 630024 630755 634468 644310 644800 644968 645247 649935 661250 666381 671739 673358 705686 717676 718968 720050 722544 733172 759658 764491 775834 776339 811040 813520 817928 821532 ] |
||||||||||||||||||||||||||||||
|
22.97 ms (11.93%) |
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 630024 451570 456859 487999 516313 457290 495402 428672 551055 722544 383387 400461 464491 459161 533628 539106 539112 539116 496298 533340 494687 473362 486699 559200 560083 569021 566347 579138 718968 546857 623231 634468 590188 619822 775834 764491 419382 459159 472358 453082 473245 473364 490843 514704 553916 811040 514733 562367 463229 543606 579372 645247 661250 630755 457332 585124 526185 543756 562371 572736 619457 490868 486390 512823 512830 386016 644800 644968 817928 821532 465905 537848 537969 533320 534789 474538 549859 550846 569202 541891 543260 582476 545408 575787 649935 666381 671739 673358 720050 552251 595735 609954 612402 629892 598452 624789 591329 598515 606566 629886 776339 813520 733172 759658 603270 644310 705686 717676 401840 453066 474566 446481 470532 523293 504964 530312 495608 421536 426518 522395 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.58%) |
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 383387 386016 400461 401840 419382 421536 426518 428672 446481 451570 453066 453082 456859 457290 457332 459159 459161 463229 464491 465905 470532 472358 473245 473362 473364 474538 474566 486390 486699 487999 490843 490868 494687 495402 495608 496298 504964 512823 512830 514704 514733 516313 522395 523293 526185 530312 533320 533340 533628 534789 537848 537969 539106 539112 539116 541891 543260 543606 543756 545408 546857 549859 550846 551055 552251 553916 559200 560083 562367 562371 566347 569021 569202 572736 575787 579138 579372 582476 585124 590188 591329 595735 598452 598515 603270 606566 609954 612402 619457 619822 623231 624789 629886 629892 630024 630755 634468 644310 644800 644968 645247 649935 661250 666381 671739 673358 705686 717676 718968 720050 722544 733172 759658 764491 775834 776339 811040 813520 817928 821532 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на money улиц group"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public money group"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на money улиц group"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.