Query Metrics
7
Database Queries
7
Different statements
149.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.69 ms (81.31%) |
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 282542 358410 382942 384310 388578 389593 390827 391289 392999 393407 393581 396079 396190 397807 398901 401807 402439 405411 407516 407570 407765 409597 412521 415468 415875 417062 417548 418046 420174 421377 424258 426395 426682 428114 428840 431390 434674 434906 435638 435744 436020 436335 437302 438576 440880 443915 445256 446934 447612 448321 448710 453504 454406 455715 456004 457912 458101 458370 458478 458594 458663 462770 462979 462983 465157 465446 465873 466258 467791 468175 469106 469783 472860 472960 473800 474802 474817 477477 480365 481000 481088 481263 481509 482031 482573 483815 487860 489014 490541 491159 492373 494896 495276 496046 499388 501334 504240 504411 509159 510110 510474 512424 515688 519122 521650 522517 527618 553992 557670 561679 563299 587865 609958 660389 701516 728308 728371 733287 793701 801065 ] |
||||||||||||||||||||||||||||||
|
17.94 ms (11.99%) |
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 438576 458478 462770 481263 424258 462983 417062 481000 437302 527618 491159 501334 504240 483815 492373 522517 482573 418046 474817 391289 426395 563299 701516 793701 733287 448710 390827 434674 455715 515688 402439 282542 458663 609958 553992 405411 426682 407765 504411 393407 388578 436020 458594 467791 389593 462979 496046 489014 561679 396190 481509 448321 409597 398901 660389 382942 393581 458101 495276 415468 510110 454406 587865 453504 415875 358410 728371 728308 469106 401807 384310 396079 457912 477477 465157 472860 417548 407570 420174 469783 468175 474802 481088 407516 480365 445256 521650 519122 392999 397807 440880 458370 456004 509159 490541 801065 443915 436335 472960 435638 494896 499388 512424 487860 447612 428114 431390 412521 435744 473800 510474 465446 557670 465873 421377 428840 434906 466258 482031 446934 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.66%) |
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 282542 358410 382942 384310 388578 389593 390827 391289 392999 393407 393581 396079 396190 397807 398901 401807 402439 405411 407516 407570 407765 409597 412521 415468 415875 417062 417548 418046 420174 421377 424258 426395 426682 428114 428840 431390 434674 434906 435638 435744 436020 436335 437302 438576 440880 443915 445256 446934 447612 448321 448710 453504 454406 455715 456004 457912 458101 458370 458478 458594 458663 462770 462979 462983 465157 465446 465873 466258 467791 468175 469106 469783 472860 472960 473800 474802 474817 477477 480365 481000 481088 481263 481509 482031 482573 483815 487860 489014 490541 491159 492373 494896 495276 496046 499388 501334 504240 504411 509159 510110 510474 512424 515688 519122 521650 522517 527618 553992 557670 561679 563299 587865 609958 660389 701516 728308 728371 733287 793701 801065 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"попу парня"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп парен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.