Query Metrics
7
Database Queries
7
Different statements
310.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
281.05 ms (90.38%) |
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 147638 192760 260297 373998 387235 392989 393314 399396 405936 406946 412194 420655 431516 440692 444526 447850 449402 454725 461384 461432 466555 468207 469847 474205 475319 483900 485277 493665 494665 496038 497524 497777 499746 499909 500227 504200 505243 507790 508470 514917 516161 520545 521954 523302 527427 530883 540911 542793 546257 549177 551149 552079 552371 555042 560738 568145 570822 571149 582605 582949 583712 583716 589146 589268 593858 594988 599226 599428 603656 608605 611167 611563 614837 620489 621977 624421 625182 628589 651251 652284 654275 654278 654290 669768 669784 671751 674467 676309 677587 696102 706933 720160 721006 721834 728493 730466 735524 748226 750746 752826 753051 754956 756242 757177 757372 772052 777913 781301 782711 788686 798671 800266 800703 800879 804700 808690 810492 813905 818471 822642 ] |
||||||||||||||||||||||||||||||
|
18.49 ms (5.95%) |
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 504200 521954 523302 483900 497524 520545 669784 599428 611563 777913 782711 772052 750746 752826 614837 461384 494665 431516 822642 447850 552079 568145 651251 677587 706933 671751 621977 788686 798671 804700 748226 810492 405936 461432 508470 393314 474205 560738 583716 542793 551149 552371 582949 676309 720160 582605 628589 611167 589146 593858 800703 753051 808690 412194 469847 147638 420655 500227 449402 454725 583712 696102 654278 625182 599226 608605 603656 620489 730466 756242 721834 260297 468207 499746 493665 514917 555042 549177 570822 589268 757372 392989 813905 507790 505243 530883 496038 571149 540911 546257 669768 674467 594988 624421 800879 754956 781301 728493 735524 757177 721006 466555 475319 499909 527427 516161 485277 497777 387235 818471 654290 800266 192760 373998 399396 406946 440692 444526 654275 652284 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (0.94%) |
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 147638 192760 260297 373998 387235 392989 393314 399396 405936 406946 412194 420655 431516 440692 444526 447850 449402 454725 461384 461432 466555 468207 469847 474205 475319 483900 485277 493665 494665 496038 497524 497777 499746 499909 500227 504200 505243 507790 508470 514917 516161 520545 521954 523302 527427 530883 540911 542793 546257 549177 551149 552079 552371 555042 560738 568145 570822 571149 582605 582949 583712 583716 589146 589268 593858 594988 599226 599428 603656 608605 611167 611563 614837 620489 621977 624421 625182 628589 651251 652284 654275 654278 654290 669768 669784 671751 674467 676309 677587 696102 706933 720160 721006 721834 728493 730466 735524 748226 750746 752826 753051 754956 756242 757177 757372 772052 777913 781301 782711 788686 798671 800266 800703 800879 804700 808690 810492 813905 818471 822642 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"two sex"
]
|
||||||||||||||||||||||||||||||
|
2.39 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"two секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"two секс"
]
|
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.