Query Metrics
7
Database Queries
7
Different statements
165.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.92 ms (82.67%) |
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 13258 161378 205520 282504 370755 387179 388847 388968 390455 400878 404418 417003 417031 428709 431893 441356 441506 445498 450013 451336 453165 453793 455494 456311 460396 461665 461814 466747 468407 468424 470123 471654 471754 472159 473932 474034 478005 478298 478512 480712 481441 481501 483187 486393 490865 495142 496504 497906 499825 500907 501723 508188 509848 510060 510190 511246 511346 514255 516697 517617 517638 520769 520788 520979 521864 523049 528123 533096 535050 535533 536887 537844 542627 544524 544752 554886 555243 558903 561694 563827 564091 564388 564832 568357 568991 574927 575430 575665 577087 578701 581213 582029 583572 584879 586999 587260 591714 592388 595549 596449 598448 601728 605802 606357 629619 636428 654177 674269 681212 684383 693225 695924 701669 722931 758731 761595 765545 784744 814582 817383 ] |
||||||||||||||||||||||||||||||
|
18.30 ms (11.05%) |
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 516697 758731 575665 388847 722931 404418 282504 387179 701669 536887 481441 684383 636428 481501 468407 471754 521864 765545 417003 428709 681212 473932 478005 511246 533096 555243 654177 388968 470123 508188 496504 520979 514255 577087 461665 453793 558903 582029 587260 601728 595549 598448 455494 490865 370755 417031 693225 586999 784744 461814 574927 431893 445498 460396 517617 535533 510060 495142 544524 564388 578701 542627 605802 480712 471654 13258 441506 520769 483187 497906 520788 468424 695924 629619 456311 761595 523049 205520 478512 501723 478298 563827 554886 564832 674269 583572 606357 591714 596449 466747 537844 509848 517638 535050 564091 568991 584879 581213 544752 592388 451336 510190 161378 441356 817383 814582 390455 486393 450013 474034 511346 500907 528123 499825 472159 561694 568357 575430 400878 453165 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (1.92%) |
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 13258 161378 205520 282504 370755 387179 388847 388968 390455 400878 404418 417003 417031 428709 431893 441356 441506 445498 450013 451336 453165 453793 455494 456311 460396 461665 461814 466747 468407 468424 470123 471654 471754 472159 473932 474034 478005 478298 478512 480712 481441 481501 483187 486393 490865 495142 496504 497906 499825 500907 501723 508188 509848 510060 510190 511246 511346 514255 516697 517617 517638 520769 520788 520979 521864 523049 528123 533096 535050 535533 536887 537844 542627 544524 544752 554886 555243 558903 561694 563827 564091 564388 564832 568357 568991 574927 575430 575665 577087 578701 581213 582029 583572 584879 586999 587260 591714 592388 595549 596449 598448 601728 605802 606357 629619 636428 654177 674269 681212 684383 693225 695924 701669 722931 758731 761595 765545 784744 814582 817383 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ridding"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал наездниц поз"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
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.