Query Metrics
7
Database Queries
7
Different statements
418.83 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding--mom--"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.16 ms |
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 786428 803957 45868 384521 391033 233670 399627 417206 522622 676591 681279 385963 383469 384282 198644 166116 395427 359062 312476 382460 38261 389643 388223 391062 413653 428456 827290 815109 817935 818338 815077 817843 824326 824501 455965 463691 470439 487608 531414 535516 540370 513063 530826 523765 531499 560094 563219 565524 572601 573757 572187 582416 543184 574191 580848 690139 714062 718772 718859 665709 670356 670513 671707 678855 685442 690810 694044 696355 707289 710590 649949 650636 673056 676586 689007 690839 696192 715244 546785 549413 574451 579189 581595 587299 587554 590164 590246 596789 606223 609799 623075 588559 589208 597546 632766 587813 592415 596189 598311 614499 623735 635916 590146 602947 779986 800880 807508 807835 808730 774690 775956 777516 784973 785051 785387 797944 801877 807577 810830 725407 ] |
||||||||||||||||||||||||||||||
| 4 | 3.76 ms |
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 38261 45868 166116 198644 233670 312476 359062 382460 383469 384282 384521 385963 388223 389643 391033 391062 395427 399627 413653 417206 428456 455965 463691 470439 487608 513063 522622 523765 530826 531414 531499 535516 540370 543184 546785 549413 560094 563219 565524 572187 572601 573757 574191 574451 579189 580848 581595 582416 587299 587554 587813 588559 589208 590146 590164 590246 592415 596189 596789 597546 598311 602947 606223 609799 614499 623075 623735 632766 635916 649949 650636 665709 670356 670513 671707 673056 676586 676591 678855 681279 685442 689007 690139 690810 690839 694044 696192 696355 707289 710590 714062 715244 718772 718859 725407 774690 775956 777516 779986 784973 785051 785387 786428 797944 800880 801877 803957 807508 807577 807835 808730 810830 815077 815109 817843 817935 818338 824326 824501 827290 ] |
||||||||||||||||||||||||||||||
| 5 | 393.68 ms |
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 38261 45868 166116 198644 233670 312476 359062 382460 383469 384282 384521 385963 388223 389643 391033 391062 395427 399627 413653 417206 428456 455965 463691 470439 487608 513063 522622 523765 530826 531414 531499 535516 540370 543184 546785 549413 560094 563219 565524 572187 572601 573757 574191 574451 579189 580848 581595 582416 587299 587554 587813 588559 589208 590146 590164 590246 592415 596189 596789 597546 598311 602947 606223 609799 614499 623075 623735 632766 635916 649949 650636 665709 670356 670513 671707 673056 676586 676591 678855 681279 685442 689007 690139 690810 690839 694044 696192 696355 707289 710590 714062 715244 718772 718859 725407 774690 775956 777516 779986 784973 785051 785387 786428 797944 800880 801877 803957 807508 807577 807835 808730 810830 815077 815109 817843 817935 818338 824326 824501 827290 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.33 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding mom"
]
|
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.