Query Metrics
7
Database Queries
7
Different statements
208.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.61 ms (86.93%) |
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 440932 445460 454167 454517 457776 462082 463707 464349 466679 466883 468342 468359 468373 471627 473325 473450 477133 483054 485947 491830 496003 497443 499346 506066 508162 513132 513968 516649 520875 523380 523876 526508 530402 531100 531556 532471 534545 536419 537264 539375 539546 544108 544503 550824 552285 554493 555076 555093 555096 555103 555282 556519 557987 559359 560390 561453 564297 565731 566875 566878 569976 573303 580029 580611 584104 590262 599527 599710 604673 614392 619593 620224 620240 623831 627362 630840 632087 660120 663772 680434 694443 714620 714811 714911 725180 725198 726974 728540 731080 733371 734324 735031 735908 736174 742351 749245 756241 759849 759958 761600 763547 776839 788980 791567 796116 802136 802151 807422 807546 808228 813085 816629 817273 817492 819353 824195 824363 826015 827973 828380 ] |
||||||||||||||||||||||||||||||
|
14.80 ms (7.09%) |
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 440932 816629 817273 824195 819353 817492 826015 824363 828380 827973 454167 462082 463707 468342 464349 466883 473325 473450 477133 485947 491830 445460 454517 457776 468373 471627 483054 523380 523876 526508 531556 532471 534545 496003 499346 513132 516649 537264 497443 513968 520875 531100 539546 506066 508162 530402 536419 539375 466679 468359 544108 554493 559359 560390 573303 580029 544503 552285 555282 556519 557987 566875 566878 580611 584104 555096 564297 565731 660120 680434 694443 714811 663772 714620 714911 550824 555076 555093 555103 561453 569976 599710 632087 590262 614392 619593 599527 620240 630840 604673 620224 623831 627362 776839 791567 802136 802151 807422 808228 813085 788980 725180 725198 726974 731080 733371 735908 742351 749245 759958 761600 763547 796116 807546 734324 736174 756241 759849 728540 735031 ] |
||||||||||||||||||||||||||||||
|
4.71 ms (2.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature dogging"
]
|
||||||||||||||||||||||||||||||
|
2.78 ms (1.33%) |
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 440932 445460 454167 454517 457776 462082 463707 464349 466679 466883 468342 468359 468373 471627 473325 473450 477133 483054 485947 491830 496003 497443 499346 506066 508162 513132 513968 516649 520875 523380 523876 526508 530402 531100 531556 532471 534545 536419 537264 539375 539546 544108 544503 550824 552285 554493 555076 555093 555096 555103 555282 556519 557987 559359 560390 561453 564297 565731 566875 566878 569976 573303 580029 580611 584104 590262 599527 599710 604673 614392 619593 620224 620240 623831 627362 630840 632087 660120 663772 680434 694443 714620 714811 714911 725180 725198 726974 728540 731080 733371 734324 735031 735908 736174 742351 749245 756241 759849 759958 761600 763547 776839 788980 791567 796116 802136 802151 807422 807546 808228 813085 816629 817273 817492 819353 824195 824363 826015 827973 828380 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature dogging"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature dogging"
]
|
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.