Query Metrics
7
Database Queries
7
Different statements
192.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.04 ms (84.63%) |
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 34382 102235 403264 420381 420459 420606 421732 421982 423427 431911 431918 432278 441176 449857 449884 451073 452890 453043 454640 457349 457653 457958 457971 459490 460863 464155 464343 464696 465052 468009 468146 469931 469966 472803 473947 474479 479492 482145 483001 484891 485138 489833 490025 490232 495740 495940 500397 500873 501133 502813 505340 505377 506406 507945 509078 509458 509742 511337 512998 515747 515805 515936 517157 518760 519608 520566 521110 521345 521434 524632 524690 525067 527598 529265 540167 541417 541872 543845 544563 545719 549560 550512 551858 560614 561259 567893 569407 570896 571257 574489 574779 574791 575115 581165 581500 583098 583632 588534 589431 592313 594564 601927 606892 647678 659321 659412 666095 676149 684178 684660 711685 752158 770136 784157 784754 788260 788262 809631 814768 825864 ] |
||||||||||||||||||||||||||||||
|
18.40 ms (9.55%) |
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 809631 457958 431911 473947 457653 469931 509078 509458 511337 500873 525067 464696 474479 423427 825864 540167 468009 594564 449857 574779 684660 521434 502813 529265 561259 788262 479492 541417 567893 676149 432278 469966 483001 449884 454640 575115 581165 788260 468146 512998 431918 814768 490232 482145 453043 452890 457971 518760 501133 489833 464343 102235 420381 472803 515805 550512 684178 601927 521110 34382 517157 551858 711685 574791 583632 569407 574489 659321 606892 420459 520566 507945 490025 421982 465052 581500 647678 560614 784157 784754 441176 459490 403264 495940 509742 527598 506406 659412 592313 545719 495740 421732 505340 549560 583098 589431 770136 451073 420606 460863 464155 500397 524632 505377 515747 515936 519608 543845 541872 570896 752158 666095 484891 588534 544563 571257 457349 524690 485138 521345 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.93%) |
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 34382 102235 403264 420381 420459 420606 421732 421982 423427 431911 431918 432278 441176 449857 449884 451073 452890 453043 454640 457349 457653 457958 457971 459490 460863 464155 464343 464696 465052 468009 468146 469931 469966 472803 473947 474479 479492 482145 483001 484891 485138 489833 490025 490232 495740 495940 500397 500873 501133 502813 505340 505377 506406 507945 509078 509458 509742 511337 512998 515747 515805 515936 517157 518760 519608 520566 521110 521345 521434 524632 524690 525067 527598 529265 540167 541417 541872 543845 544563 545719 549560 550512 551858 560614 561259 567893 569407 570896 571257 574489 574779 574791 575115 581165 581500 583098 583632 588534 589431 592313 594564 601927 606892 647678 659321 659412 666095 676149 684178 684660 711685 752158 770136 784157 784754 788260 788262 809631 814768 825864 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"игра на секс"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"игр на секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.84%) |
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.