Query Metrics
7
Database Queries
7
Different statements
150.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.98 ms (81.74%) |
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 96100 96231 122925 130054 333214 362588 383742 387301 390607 396744 400461 401904 403141 408458 413895 424406 430088 434668 443962 446476 454268 454367 472431 476753 486260 488724 496711 499111 514816 521970 531207 531256 532744 532916 533003 533855 533949 534992 536579 537206 537686 537776 540334 540348 543850 547997 548609 562842 565249 577376 597236 597242 597271 598057 600329 601994 603236 628379 628388 628410 631948 632658 632684 632697 633768 637431 637432 639762 641638 641667 642687 644968 645237 646448 647910 648850 650158 650326 651062 651620 651855 651856 652978 656499 656502 656507 659321 666867 666879 670227 672984 674943 676095 676097 677730 679716 679761 679772 680120 680121 680167 680202 681005 695199 695262 699631 702164 702927 703830 704715 706652 708444 715682 720050 733849 748950 758979 814246 817451 820777 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (11.46%) |
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 603236 401904 533949 536579 537206 548609 565249 702164 702927 598057 632697 639762 628379 628388 641667 633768 537686 650158 499111 674943 642687 476753 488724 676097 680167 122925 403141 434668 408458 496711 531207 534992 537776 531256 532744 533855 540348 472431 486260 562842 577376 656507 679772 706652 648850 666867 679716 708444 650326 651620 679761 681005 637431 637432 597271 600329 632658 632684 597236 733849 758979 748950 631948 703830 390607 413895 454268 333214 396744 514816 521970 646448 383742 130054 362588 96100 96231 387301 400461 424406 443962 430088 644968 820777 814246 817451 446476 454367 540334 533003 532916 543850 547997 651062 656499 670227 672984 680202 695199 647910 651855 651856 652978 656502 666879 676095 680120 695262 699631 704715 715682 645237 659321 677730 680121 720050 601994 641638 597242 628410 ] |
||||||||||||||||||||||||||||||
|
3.03 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 96100 96231 122925 130054 333214 362588 383742 387301 390607 396744 400461 401904 403141 408458 413895 424406 430088 434668 443962 446476 454268 454367 472431 476753 486260 488724 496711 499111 514816 521970 531207 531256 532744 532916 533003 533855 533949 534992 536579 537206 537686 537776 540334 540348 543850 547997 548609 562842 565249 577376 597236 597242 597271 598057 600329 601994 603236 628379 628388 628410 631948 632658 632684 632697 633768 637431 637432 639762 641638 641667 642687 644968 645237 646448 647910 648850 650158 650326 651062 651620 651855 651856 652978 656499 656502 656507 659321 666867 666879 670227 672984 674943 676095 676097 677730 679716 679761 679772 680120 680121 680167 680202 681005 695199 695262 699631 702164 702927 703830 704715 706652 708444 715682 720050 733849 748950 758979 814246 817451 820777 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал teen group"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal teen group"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал teen group"
]
|
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.