Query Metrics
7
Database Queries
7
Different statements
161.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.24 ms (78.99%) |
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 3320 68246 68383 68412 100075 100616 213932 342206 383076 385754 387851 391864 392554 395794 396753 398745 400723 401390 401631 402513 403906 404150 409416 418975 419943 425566 426672 426715 428033 429554 443040 447013 447550 447757 457410 457411 459120 460721 462575 462580 462937 469909 469910 469916 470001 470185 470382 473251 474027 475517 477045 477410 479288 483373 484827 484830 484857 485916 490008 490815 491665 491971 492042 494323 496135 497171 497534 497578 504302 507341 509758 516822 521996 522796 523295 523508 524259 527664 530386 534947 535913 540953 543819 543822 546659 547905 548628 549280 549357 551194 551232 551241 557725 560423 560452 562254 562257 562630 570586 570635 571076 578375 578390 579384 580629 585776 602971 605143 605764 608160 616269 626274 627748 652996 655088 729460 741048 757321 761614 782634 ] |
||||||||||||||||||||||||||||||
|
19.14 ms (11.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 484830 523508 470382 494323 443040 534947 401390 562630 535913 429554 68412 530386 426672 546659 404150 578390 516822 523295 527664 560452 547905 540953 485916 602971 491665 497534 342206 469909 557725 605764 652996 543822 3320 395794 213932 383076 419943 402513 68246 782634 387851 426715 497171 409416 626274 477045 385754 457411 396753 616269 492042 757321 474027 549280 509758 447550 655088 761614 100075 68383 570635 578375 479288 392554 391864 469910 473251 729460 475517 551232 490815 484857 459120 428033 470185 627748 571076 580629 460721 100616 548628 551241 524259 400723 491971 425566 477410 469916 522796 562254 562257 543819 608160 490008 521996 462580 741048 483373 462937 497578 549357 570586 585776 579384 401631 507341 496135 398745 484827 504302 457410 418975 462575 560423 447757 403906 447013 605143 551194 470001 ] |
||||||||||||||||||||||||||||||
|
5.43 ms (3.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пьян девушк секс"
]
|
||||||||||||||||||||||||||||||
|
3.24 ms (2.01%) |
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 3320 68246 68383 68412 100075 100616 213932 342206 383076 385754 387851 391864 392554 395794 396753 398745 400723 401390 401631 402513 403906 404150 409416 418975 419943 425566 426672 426715 428033 429554 443040 447013 447550 447757 457410 457411 459120 460721 462575 462580 462937 469909 469910 469916 470001 470185 470382 473251 474027 475517 477045 477410 479288 483373 484827 484830 484857 485916 490008 490815 491665 491971 492042 494323 496135 497171 497534 497578 504302 507341 509758 516822 521996 522796 523295 523508 524259 527664 530386 534947 535913 540953 543819 543822 546659 547905 548628 549280 549357 551194 551232 551241 557725 560423 560452 562254 562257 562630 570586 570635 571076 578375 578390 579384 580629 585776 602971 605143 605764 608160 616269 626274 627748 652996 655088 729460 741048 757321 761614 782634 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пьян девушк секс"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"drunk girl fuck"
]
|
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.