Query Metrics
7
Database Queries
7
Different statements
161.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.98 ms (84.75%) |
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 401035 412311 416015 425633 429926 434346 438054 445015 447230 453043 454972 455591 456518 456525 457958 460444 464072 464343 469030 469530 469966 469983 470442 472163 472569 472743 474787 476290 478829 482275 482355 486383 488774 489212 492096 492108 495752 502147 502762 510456 510504 512347 512895 515358 515919 519705 522159 523068 526124 526444 530160 532942 535616 541671 541821 545336 546028 548316 551761 552597 553505 555521 564342 567723 569020 570896 575198 575998 576219 580160 582301 582531 583035 585516 588595 589150 592974 594564 595797 599657 602578 602834 603830 604849 605002 605597 606838 606873 606946 615427 616864 620215 620257 626367 633527 637559 639810 644380 667352 721014 725411 726635 734140 744307 769013 774912 784157 784184 784494 788994 792555 795406 796862 798351 800570 806733 807208 809191 812749 819320 ] |
||||||||||||||||||||||||||||||
|
15.28 ms (9.45%) |
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 472163 519705 512895 492096 412311 576219 469030 541821 474787 819320 488774 453043 455591 482275 522159 526124 530160 476290 545336 552597 553505 575998 588595 589150 615427 637559 633527 595797 605597 605002 606873 784494 734140 796862 807208 726635 725411 769013 798351 457958 469983 502762 482355 456518 445015 582531 470442 489212 416015 454972 469530 570896 626367 472569 456525 548316 551761 564342 580160 721014 603830 592974 602578 602834 644380 792555 800570 774912 788994 806733 744307 606838 478829 464072 429926 469966 510456 510504 515919 535616 567723 575198 594564 460444 472743 523068 512347 620257 515358 532942 502147 639810 495752 425633 492108 616864 620215 541671 438054 464343 486383 526444 569020 546028 555521 582301 583035 667352 604849 599657 585516 606946 809191 795406 784157 812749 784184 434346 401035 447230 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.84%) |
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 401035 412311 416015 425633 429926 434346 438054 445015 447230 453043 454972 455591 456518 456525 457958 460444 464072 464343 469030 469530 469966 469983 470442 472163 472569 472743 474787 476290 478829 482275 482355 486383 488774 489212 492096 492108 495752 502147 502762 510456 510504 512347 512895 515358 515919 519705 522159 523068 526124 526444 530160 532942 535616 541671 541821 545336 546028 548316 551761 552597 553505 555521 564342 567723 569020 570896 575198 575998 576219 580160 582301 582531 583035 585516 588595 589150 592974 594564 595797 599657 602578 602834 603830 604849 605002 605597 606838 606873 606946 615427 616864 620215 620257 626367 633527 637559 639810 644380 667352 721014 725411 726635 734140 744307 769013 774912 784157 784184 784494 788994 792555 795406 796862 798351 800570 806733 807208 809191 812749 819320 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother game"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин игр"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.85%) |
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.