Query Metrics
7
Database Queries
7
Different statements
165.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.87 ms (80.21%) |
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 414381 417866 418538 420125 422411 422709 428116 430081 432131 435428 439854 443636 445903 446633 447706 447803 459099 464623 468012 469023 477412 478530 478832 479002 479826 484433 484636 486217 486885 487197 488030 488372 489120 489173 489891 490378 491169 491286 491784 491885 493892 494276 496270 496722 496987 497300 497409 497866 497899 501081 501329 501414 501598 503405 508438 509816 511160 511809 513573 514071 515508 516141 516820 516989 517118 517144 518206 518917 519752 519879 519907 520555 520740 521241 521343 522050 522110 522441 522949 523577 524029 524089 524149 524309 524633 525047 525087 525232 527576 527886 528791 529710 529855 530005 530048 530832 533450 533844 536262 538270 543871 546794 550093 550348 556774 559142 584013 589290 593863 596851 603218 604369 606695 620619 628294 634185 638991 677798 698847 727648 ] |
||||||||||||||||||||||||||||||
|
22.00 ms (13.28%) |
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 501081 509816 490378 497300 517144 521241 525087 525232 493892 517118 519752 519879 533450 488372 489891 496722 496987 521343 522441 523577 524633 525047 527886 550348 546794 422709 418538 414381 417866 484433 486217 487197 489173 511809 524089 494276 497899 516989 518917 527576 530005 530048 501598 514071 543871 550093 556774 677798 634185 638991 628294 604369 620619 435428 446633 478530 479826 459099 439854 468012 511160 524149 489120 491169 491885 508438 520740 529710 491286 501414 524309 488030 516141 520555 727648 538270 428116 443636 445903 469023 464623 501329 522110 528791 529855 536262 533844 584013 606695 603218 593863 447803 478832 430081 518206 524029 484636 522050 491784 497866 515508 486885 698847 420125 479002 447706 503405 519907 530832 559142 596851 589290 422411 432131 477412 513573 516820 496270 497409 522949 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.78%) |
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 414381 417866 418538 420125 422411 422709 428116 430081 432131 435428 439854 443636 445903 446633 447706 447803 459099 464623 468012 469023 477412 478530 478832 479002 479826 484433 484636 486217 486885 487197 488030 488372 489120 489173 489891 490378 491169 491286 491784 491885 493892 494276 496270 496722 496987 497300 497409 497866 497899 501081 501329 501414 501598 503405 508438 509816 511160 511809 513573 514071 515508 516141 516820 516989 517118 517144 518206 518917 519752 519879 519907 520555 520740 521241 521343 522050 522110 522441 522949 523577 524029 524089 524149 524309 524633 525047 525087 525232 527576 527886 528791 529710 529855 530005 530048 530832 533450 533844 536262 538270 543871 546794 550093 550348 556774 559142 584013 589290 593863 596851 603218 604369 606695 620619 628294 634185 638991 677798 698847 727648 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tied up fucked"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм fucked"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бдсм fucked"
]
|
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.