Query Metrics
7
Database Queries
7
Different statements
373.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.31 ms (55.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs sex"
]
|
||||||||||||||||||||||||||||||
|
143.49 ms (38.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 95700 185432 394152 398382 401640 410319 420785 422210 424644 425619 426412 427561 435162 439634 440156 444698 445404 446948 448373 448896 448906 451883 453565 453922 454061 454072 456322 456613 456615 456625 460172 463737 464312 464381 464687 464952 465290 465685 466671 468856 469548 469832 472063 474720 475079 478839 478840 479212 480848 481253 484541 485699 486809 487543 492376 492711 493845 506350 511327 514273 518449 519701 520923 525480 527054 528839 529422 530130 535012 539800 543107 545639 546106 551018 557135 568581 572929 577353 580916 582792 583341 584434 597857 605646 610603 612276 613224 618972 619480 619511 620323 624178 624739 625709 631710 640895 643489 669223 693781 712177 712423 715394 722718 732367 750454 758248 759960 772547 787748 791034 797835 798963 801065 801098 801112 802239 802783 812765 828397 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (4.07%) |
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 798952 801098 772547 750454 759960 732367 529422 427561 456613 456625 486809 511327 528839 466671 475079 577353 583341 722718 568581 620323 643489 791034 624739 464381 464952 481253 479212 446948 465290 468856 464312 478839 425619 546106 624178 439634 185432 398382 410319 435162 484541 453565 454072 525480 519701 597857 422210 454061 401640 424644 506350 518449 618972 456615 543107 448373 460172 485699 487543 520923 535012 539800 530130 464687 572929 582792 584434 693781 712177 715394 605646 612276 640895 610603 631710 797835 802239 394152 448896 445404 469548 514273 493845 465685 580916 712423 613224 787748 802783 801065 801112 758248 625709 798963 812765 453922 478840 448906 828397 557135 551018 420785 451883 492711 472063 492376 527054 545639 669223 619511 619480 444698 463737 426412 440156 95700 456322 469832 474720 480848 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.80%) |
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 95700 185432 394152 398382 401640 410319 420785 422210 424644 425619 426412 427561 435162 439634 440156 444698 445404 446948 448373 448896 448906 451883 453565 453922 454061 454072 456322 456613 456615 456625 460172 463737 464312 464381 464687 464952 465290 465685 466671 468856 469548 469832 472063 474720 475079 478839 478840 479212 480848 481253 484541 485699 486809 487543 492376 492711 493845 506350 511327 514273 518449 519701 520923 525480 527054 528839 529422 530130 535012 539800 543107 545639 546106 551018 557135 568581 572929 577353 580916 582792 583341 584434 597857 605646 610603 612276 613224 618972 619480 619511 620323 624178 624739 625709 631710 640895 643489 669223 693781 712177 712423 715394 722718 732367 750454 758248 759960 772547 787748 791034 797835 798963 801065 801098 801112 802239 802783 812765 828397 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs секс"
]
|
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.