Query Metrics
7
Database Queries
7
Different statements
161.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.36 ms (79.91%) |
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 386142 389024 391521 392820 395596 395733 404612 406019 407039 407662 410057 412433 415658 417435 419245 421907 423301 443859 445473 445627 447089 451928 456201 459397 462700 463783 464266 465834 466097 467338 470596 472388 474024 475166 475807 477327 482088 484069 484090 484661 484708 485083 487339 490418 491802 500578 502745 503194 505004 514748 515223 517048 518842 519945 523480 524012 525118 525263 527765 538290 540098 548655 548684 550232 550507 551137 553661 563196 563887 565536 566272 567337 568125 571509 576023 579279 579713 581662 581692 581693 583262 585136 585141 590500 590966 594920 601161 605650 606731 606761 607100 607256 610179 618888 623618 624392 628175 663854 665381 666113 670041 672805 677142 684213 688050 713520 714840 721057 721435 730270 748349 758180 797462 803796 804776 806783 810765 811998 813252 814266 ] |
||||||||||||||||||||||||||||||
|
22.46 ms (13.88%) |
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 472388 475807 484708 502745 484661 487339 466097 517048 624392 525118 395733 389024 406019 410057 417435 419245 443859 423301 585141 445473 527765 540098 563196 565536 550507 579713 670041 684213 713520 714840 721435 663854 665381 666113 672805 548684 579279 583262 606731 590500 610179 607100 811998 813252 797462 730270 748349 758180 618888 803796 391521 465834 524012 814266 456201 568125 688050 567337 605650 623618 606761 407039 505004 551137 482088 566272 563887 607256 451928 447089 538290 553661 470596 484069 525263 415658 462700 477327 464266 503194 421907 474024 412433 677142 628175 500578 490418 590966 386142 392820 404612 585136 467338 523480 484090 576023 581662 548655 581692 581693 550232 571509 594920 601161 810765 806783 721057 804776 407662 395596 463783 475166 459397 514748 518842 485083 519945 491802 515223 445627 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.65%) |
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 386142 389024 391521 392820 395596 395733 404612 406019 407039 407662 410057 412433 415658 417435 419245 421907 423301 443859 445473 445627 447089 451928 456201 459397 462700 463783 464266 465834 466097 467338 470596 472388 474024 475166 475807 477327 482088 484069 484090 484661 484708 485083 487339 490418 491802 500578 502745 503194 505004 514748 515223 517048 518842 519945 523480 524012 525118 525263 527765 538290 540098 548655 548684 550232 550507 551137 553661 563196 563887 565536 566272 567337 568125 571509 576023 579279 579713 581662 581692 581693 583262 585136 585141 590500 590966 594920 601161 605650 606731 606761 607100 607256 610179 618888 623618 624392 628175 663854 665381 666113 670041 672805 677142 684213 688050 713520 714840 721057 721435 730270 748349 758180 797462 803796 804776 806783 810765 811998 813252 814266 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old man wife"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old мужчин жен"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old мужчин жен"
]
|
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.