Query Metrics
7
Database Queries
7
Different statements
370.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.97 ms (57.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real русск"
]
|
||||||||||||||||||||||||||||||
|
125.54 ms (33.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 400494 418145 421810 421825 421831 421840 421875 421876 422152 422159 424049 424658 428965 433371 433380 433920 436437 438767 439685 439697 439728 439764 439770 439808 440601 443607 443801 444698 445310 448773 455343 455351 455941 457786 458191 460535 462569 465381 469648 474776 475378 475873 478379 478969 481406 481580 483644 489220 489649 491373 491924 493917 496585 497567 497584 498656 501732 504196 504279 504450 505039 506677 506794 507276 507817 507976 508003 509891 510619 511752 513498 516483 516740 517287 517832 518824 519322 519512 519859 521545 523301 523740 525224 525700 525953 527358 527706 528262 530001 541084 541575 542042 544386 556496 557946 557953 559485 561273 561385 562853 568961 574566 591214 598133 601852 605698 608230 609197 609531 619526 620116 623681 624137 628443 657780 666530 679398 690034 732905 810109 ] |
||||||||||||||||||||||||||||||
|
23.16 ms (6.24%) |
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 628443 732905 421840 424049 469648 421875 422152 438767 436437 445310 433920 439685 443801 455343 465381 421825 481406 504196 509891 516740 493917 497567 511752 519322 525700 527358 489220 491373 504279 505039 510619 516483 489649 496585 497584 517832 609531 455351 440601 478379 439728 455941 457786 478969 518824 507276 507976 544386 561385 562853 541575 556496 557953 559485 542042 561273 679398 657780 666530 690034 568961 601852 605698 623681 591214 620116 624137 609197 422159 428965 433380 460535 400494 421810 444698 481580 421831 424658 421876 439770 439808 475378 418145 433371 439697 443607 508003 523740 530001 501732 507817 513498 523301 491924 498656 519859 525224 527706 483644 506677 506794 517287 519512 521545 528262 608230 810109 448773 619526 439764 458191 474776 475873 541084 598133 504450 525953 462569 557946 574566 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real russian"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.54%) |
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 400494 418145 421810 421825 421831 421840 421875 421876 422152 422159 424049 424658 428965 433371 433380 433920 436437 438767 439685 439697 439728 439764 439770 439808 440601 443607 443801 444698 445310 448773 455343 455351 455941 457786 458191 460535 462569 465381 469648 474776 475378 475873 478379 478969 481406 481580 483644 489220 489649 491373 491924 493917 496585 497567 497584 498656 501732 504196 504279 504450 505039 506677 506794 507276 507817 507976 508003 509891 510619 511752 513498 516483 516740 517287 517832 518824 519322 519512 519859 521545 523301 523740 525224 525700 525953 527358 527706 528262 530001 541084 541575 542042 544386 556496 557946 557953 559485 561273 561385 562853 568961 574566 591214 598133 601852 605698 608230 609197 609531 619526 620116 623681 624137 628443 657780 666530 679398 690034 732905 810109 ] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real русск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.42%) |
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.