Query Metrics
7
Database Queries
7
Different statements
203.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.35 ms (86.33%) |
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 6941 90979 201859 322014 378401 404946 408463 428381 442189 444732 447908 455971 458855 458892 459592 459603 459711 460863 461232 461361 469426 469497 472438 473206 474141 474854 475040 476045 476439 479406 479948 482145 488697 489902 489906 490187 492517 492521 495247 498051 502299 502899 504328 504405 504998 505937 510533 511009 511930 514818 514831 515294 516831 518321 519620 520925 523088 526901 529245 533991 535830 547835 554525 555750 555793 559037 561358 565103 565186 570429 571375 576281 578454 580365 586500 586506 590556 591641 593344 593408 593543 596586 604137 611349 617680 639722 655550 659361 663887 664688 666763 673057 673063 675165 682073 684193 685589 688645 696082 696976 709900 721096 724124 795355 814744 814776 814880 815207 815257 815333 815470 815480 815485 815511 815733 815769 815862 815904 816237 816420 ] |
||||||||||||||||||||||||||||||
|
17.15 ms (8.44%) |
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 815333 815207 816420 673063 696082 404946 476439 504998 505937 596586 511009 578454 673057 378401 459592 489902 554525 795355 815480 815904 814880 461361 611349 696976 473206 815769 586506 590556 502299 459603 518321 479948 482145 533991 580365 571375 6941 565186 322014 458892 498051 664688 555793 504328 511930 516831 814744 535830 682073 90979 815257 815470 815862 816237 814776 815511 570429 655550 666763 593408 604137 724124 617680 721096 479406 476045 474854 555750 659361 663887 593543 458855 504405 515294 519620 639722 447908 685589 688645 559037 514831 514818 523088 815485 815733 576281 675165 709900 520925 488697 565103 561358 591641 455971 469497 442189 459711 510533 475040 684193 593344 461232 472438 460863 502899 492517 492521 529245 495247 526901 201859 444732 474141 490187 489906 547835 586500 408463 469426 428381 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.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 6941 90979 201859 322014 378401 404946 408463 428381 442189 444732 447908 455971 458855 458892 459592 459603 459711 460863 461232 461361 469426 469497 472438 473206 474141 474854 475040 476045 476439 479406 479948 482145 488697 489902 489906 490187 492517 492521 495247 498051 502299 502899 504328 504405 504998 505937 510533 511009 511930 514818 514831 515294 516831 518321 519620 520925 523088 526901 529245 533991 535830 547835 554525 555750 555793 559037 561358 565103 565186 570429 571375 576281 578454 580365 586500 586506 590556 591641 593344 593408 593543 596586 604137 611349 617680 639722 655550 659361 663887 664688 666763 673057 673063 675165 682073 684193 685589 688645 696082 696976 709900 721096 724124 795355 814744 814776 814880 815207 815257 815333 815470 815480 815485 815511 815733 815769 815862 815904 816237 816420 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doctor dick"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доктор член"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.78%) |
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.