Query Metrics
7
Database Queries
7
Different statements
172.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.81 ms (86.09%) |
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 154171 210106 266977 321285 382665 391959 392006 454023 455005 457635 460908 469046 471043 472698 488987 491242 517490 523371 527923 529865 530412 531058 535364 535371 536323 537087 540567 543951 544981 545971 546104 547979 549675 555007 556586 558094 558102 563086 570885 574395 587552 589652 591162 592965 592969 593039 599236 599354 599765 602165 602585 602782 605245 606051 607703 619638 628617 629799 629978 639647 660025 664574 710732 712129 714112 714364 714399 714409 715111 715472 719384 720524 728466 733425 736009 736740 740450 742352 742358 744186 744192 749019 749050 753663 754293 759124 776736 785834 787341 788319 790825 797146 798311 799644 803820 803883 804241 804456 805359 805949 806540 809297 810088 811604 811871 812408 812541 816382 817590 817873 819239 819254 819861 823994 824212 824502 825426 826856 827100 827395 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (7.84%) |
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 574395 547979 558102 710732 715472 715111 599765 602585 606051 619638 593039 607703 639647 812408 790825 728466 736009 749019 753663 754293 759124 816382 805359 549675 535364 720524 592969 629978 811871 742352 744186 776736 809297 591162 471043 714399 712129 714409 546104 788319 803820 457635 491242 517490 556586 629799 527923 154171 392006 321285 523371 469046 545971 602782 599236 742358 391959 488987 827395 540567 536323 529865 664574 592965 605245 714364 558094 472698 555007 599354 628617 602165 460908 210106 825426 827100 817590 824212 454023 455005 544981 570885 563086 589652 797146 799644 805949 787341 804241 804456 806540 810088 812541 740450 736740 749050 744192 733425 798311 811604 382665 817873 824502 819254 819239 537087 587552 266977 819861 826856 823994 530412 531058 535371 543951 660025 714112 719384 785834 803883 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.32%) |
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 154171 210106 266977 321285 382665 391959 392006 454023 455005 457635 460908 469046 471043 472698 488987 491242 517490 523371 527923 529865 530412 531058 535364 535371 536323 537087 540567 543951 544981 545971 546104 547979 549675 555007 556586 558094 558102 563086 570885 574395 587552 589652 591162 592965 592969 593039 599236 599354 599765 602165 602585 602782 605245 606051 607703 619638 628617 629799 629978 639647 660025 664574 710732 712129 714112 714364 714399 714409 715111 715472 719384 720524 728466 733425 736009 736740 740450 742352 742358 744186 744192 749019 749050 753663 754293 759124 776736 785834 787341 788319 790825 797146 798311 799644 803820 803883 804241 804456 805359 805949 806540 809297 810088 811604 811871 812408 812541 816382 817590 817873 819239 819254 819861 823994 824212 824502 825426 826856 827100 827395 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits mature solo"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ mature соло"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ mature соло"
]
|
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.