Query Metrics
7
Database Queries
7
Different statements
144.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.91 ms (82.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 389829 419655 420881 421172 421414 424420 433561 436952 439656 439721 441496 447350 447883 450861 451428 451854 453426 454566 455064 455430 455515 458311 460366 462995 466154 467484 467510 467513 467696 469014 470988 473241 475189 477608 478168 479953 481528 482505 482520 482530 483130 486892 487133 489016 491040 491319 491321 491373 491724 492994 493382 493567 494013 495252 496738 497567 499009 501997 502929 503770 503914 504889 507077 508735 509620 511303 515592 516096 516748 517859 519665 519676 520093 521928 521977 523455 525879 525899 528217 528429 540953 541499 546414 549587 551246 552790 552791 555141 558609 558742 558770 559532 559791 561354 562266 566102 567685 569281 569288 571776 571784 573267 586493 589750 594644 598914 607750 609133 611507 614264 620251 620749 625218 626381 627660 650303 666530 667052 712557 757750 ] |
||||||||||||||||||||||||||||||
|
16.20 ms (11.22%) |
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 569288 667052 598914 757750 460366 479953 421414 467510 507077 501997 525879 483130 504889 561354 469014 441496 573267 625218 611507 419655 477608 520093 528429 450861 540953 571784 467696 515592 499009 492994 614264 451428 503914 589750 517859 482520 559532 626381 470988 523455 491321 493567 433561 609133 389829 516748 712557 497567 558770 503770 521928 519665 620749 421172 473241 521977 455515 519676 487133 558609 571776 586493 420881 447350 454566 491373 486892 467484 552791 650303 549587 627660 458311 491040 493382 496738 546414 559791 552790 569281 594644 607750 447883 451854 424420 462995 466154 525899 516096 482505 482530 491319 467513 558742 439721 436952 489016 491724 494013 541499 453426 481528 478168 455064 511303 502929 509620 567685 620251 528217 495252 439656 508735 566102 475189 455430 562266 666530 551246 555141 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.76%) |
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 389829 419655 420881 421172 421414 424420 433561 436952 439656 439721 441496 447350 447883 450861 451428 451854 453426 454566 455064 455430 455515 458311 460366 462995 466154 467484 467510 467513 467696 469014 470988 473241 475189 477608 478168 479953 481528 482505 482520 482530 483130 486892 487133 489016 491040 491319 491321 491373 491724 492994 493382 493567 494013 495252 496738 497567 499009 501997 502929 503770 503914 504889 507077 508735 509620 511303 515592 516096 516748 517859 519665 519676 520093 521928 521977 523455 525879 525899 528217 528429 540953 541499 546414 549587 551246 552790 552791 555141 558609 558742 558770 559532 559791 561354 562266 566102 567685 569281 569288 571776 571784 573267 586493 589750 594644 598914 607750 609133 611507 614264 620251 620749 625218 626381 627660 650303 666530 667052 712557 757750 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sex student"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск секс student"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск секс student"
]
|
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.