Query Metrics
7
Database Queries
7
Different statements
146.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.20 ms (82.29%) |
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 188379 383439 394751 399354 409784 410843 414177 415935 416069 419527 420392 421415 426712 428801 429049 429153 430776 432466 432547 435405 437943 439553 439635 443130 443573 445949 447012 448461 449863 451438 451542 451966 452957 453238 456897 459271 459879 461125 461324 464072 464124 464212 465193 465611 466781 467283 468041 470067 471056 475441 475900 479053 482081 483190 483869 484106 484561 485719 485738 486737 487933 488541 489616 489995 491450 491474 494970 497206 497478 498270 498411 498457 499394 500623 503418 504069 507200 507829 512429 512990 515235 515854 520336 521791 523037 523453 524006 524242 525483 525808 526368 526860 551038 552089 557851 560553 561629 562012 567773 570137 570537 577372 581708 586532 590706 592719 592747 598554 598861 599309 606802 613855 618610 620323 636478 639908 650307 695427 723435 788549 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (10.80%) |
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 485738 590706 586532 485719 521791 620323 443130 618610 723435 592719 567773 484106 415935 471056 466781 581708 592747 461125 488541 507200 420392 577372 432547 394751 449863 525808 695427 429049 520336 507829 497206 512990 448461 437943 470067 452957 489616 464072 465193 498411 468041 515854 499394 639908 419527 598861 483869 416069 383439 429153 524006 409784 523453 504069 435405 491474 503418 562012 526860 461324 491450 636478 426712 788549 606802 494970 188379 479053 570537 599309 445949 552089 498270 484561 443573 570137 467283 497478 447012 557851 525483 489995 439635 475441 430776 414177 459271 421415 498457 500623 613855 451438 526368 551038 432466 524242 410843 512429 451542 456897 451966 482081 515235 464212 483190 475900 486737 459879 650307 523037 561629 428801 560553 598554 399354 453238 464124 439553 487933 465611 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.77%) |
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 188379 383439 394751 399354 409784 410843 414177 415935 416069 419527 420392 421415 426712 428801 429049 429153 430776 432466 432547 435405 437943 439553 439635 443130 443573 445949 447012 448461 449863 451438 451542 451966 452957 453238 456897 459271 459879 461125 461324 464072 464124 464212 465193 465611 466781 467283 468041 470067 471056 475441 475900 479053 482081 483190 483869 484106 484561 485719 485738 486737 487933 488541 489616 489995 491450 491474 494970 497206 497478 498270 498411 498457 499394 500623 503418 504069 507200 507829 512429 512990 515235 515854 520336 521791 523037 523453 524006 524242 525483 525808 526368 526860 551038 552089 557851 560553 561629 562012 567773 570137 570537 577372 581708 586532 590706 592719 592747 598554 598861 599309 606802 613855 618610 620323 636478 639908 650307 695427 723435 788549 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"no tits blowjob"
]
|
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.