Query Metrics
7
Database Queries
7
Different statements
140.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.61 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.15 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кара"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.80 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 601028 605058 606541 621756 624742 609803 468941 518622 514457 469552 480382 492097 502468 523408 526359 495392 502147 512928 564327 550228 558441 670089 653219 654617 563456 586519 590749 599533 612799 724305 482313 472155 491782 517076 529355 524104 525113 507651 524508 474643 567151 543061 562000 562361 566597 652893 658269 655705 550315 594802 618762 596856 608358 617370 520145 497779 545015 572026 582730 550415 562358 562531 612698 621946 599317 609140 590221 613867 457103 498043 532246 494617 522865 502533 559392 543772 671863 584704 615429 621735 587896 504718 492736 515723 527048 562825 549225 632059 ] |
||||||||||||||||||||||||||||||
| 4 | 3.12 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 457103 468941 469552 472155 474643 480382 482313 491782 492097 492736 494617 495392 497779 498043 502147 502468 502533 504718 507651 512928 514457 515723 517076 518622 520145 522865 523408 524104 524508 525113 526359 527048 529355 532246 543061 543772 545015 549225 550228 550315 550415 558441 559392 562000 562358 562361 562531 562825 563456 564327 566597 567151 572026 582730 584704 586519 587896 590221 594802 596856 599317 599533 601028 605058 606541 608358 609140 609803 612698 612799 613867 615429 617370 618762 621735 621756 621946 624742 632059 652893 653219 654617 655705 658269 670089 671863 724305 ] |
||||||||||||||||||||||||||||||
| 5 | 111.71 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 457103 468941 469552 472155 474643 480382 482313 491782 492097 492736 494617 495392 497779 498043 502147 502468 502533 504718 507651 512928 514457 515723 517076 518622 520145 522865 523408 524104 524508 525113 526359 527048 529355 532246 543061 543772 545015 549225 550228 550315 550415 558441 559392 562000 562358 562361 562531 562825 563456 564327 566597 567151 572026 582730 584704 586519 587896 590221 594802 596856 599317 599533 601028 605058 606541 608358 609140 609803 612698 612799 613867 615429 617370 618762 621735 621756 621946 624742 632059 652893 653219 654617 655705 658269 670089 671863 724305 ] |
||||||||||||||||||||||||||||||
| 6 | 1.78 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кар"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.61 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.