Query Metrics
7
Database Queries
7
Different statements
423.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.37 ms (49.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding cum"
]
|
||||||||||||||||||||||||||||||
|
186.17 ms (43.96%) |
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 81656 385925 389310 389643 393526 394162 395427 396449 416444 424853 428079 432381 432789 433304 433834 434602 441603 441648 441664 442011 442051 442467 449545 449709 452429 452739 453043 453993 455560 456005 457486 458082 459421 460053 460814 463691 468978 468991 468996 475305 475730 478111 479440 480164 480844 483108 484231 488982 489451 491536 492966 497753 499759 501316 503711 504098 504950 511623 513861 514810 520869 525744 527228 528741 535516 541016 544619 545568 552813 555905 560269 562946 569591 572791 572818 574329 577932 581104 584501 584570 625709 645310 646927 647085 650736 663192 674907 676776 677517 678759 684154 693410 699292 700031 700724 709118 710966 715089 716536 718804 718810 724928 726941 728521 739178 742149 746736 752766 755471 755483 756659 761712 763896 764165 768675 771922 779607 803957 804878 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (4.16%) |
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 742149 724928 728521 763896 764165 768675 726941 739178 746736 756659 771922 752766 755471 755483 761712 625709 699292 700031 710966 716536 779607 803957 804878 393526 396449 424853 432789 433834 460053 501316 491536 520869 504098 385925 81656 394162 395427 389310 389643 441664 441603 442011 442051 442467 428079 434602 416444 432381 433304 441648 457486 463691 480844 484231 489451 492966 449709 452429 453993 456005 468996 475730 479440 488982 449545 452739 453043 455560 458082 459421 468978 475305 478111 499759 527228 535516 504950 525744 497753 511623 528741 503711 513861 514810 460814 468991 480164 483108 544619 555905 560269 562946 572791 572818 574329 584570 545568 552813 569591 577932 581104 584501 541016 663192 674907 677517 693410 715089 718810 646927 650736 676776 678759 700724 709118 718804 645310 647085 659047 684154 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.72%) |
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 81656 385925 389310 389643 393526 394162 395427 396449 416444 424853 428079 432381 432789 433304 433834 434602 441603 441648 441664 442011 442051 442467 449545 449709 452429 452739 453043 453993 455560 456005 457486 458082 459421 460053 460814 463691 468978 468991 468996 475305 475730 478111 479440 480164 480844 483108 484231 488982 489451 491536 492966 497753 499759 501316 503711 504098 504950 511623 513861 514810 520869 525744 527228 528741 535516 541016 544619 545568 552813 555905 560269 562946 569591 572791 572818 574329 577932 581104 584501 584570 625709 645310 646927 647085 650736 663192 674907 676776 677517 678759 684154 693410 699292 700031 700724 709118 710966 715089 716536 718804 718810 724928 726941 728521 739178 742149 746736 752766 755471 755483 756659 761712 763896 764165 768675 771922 779607 803957 804878 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding cum"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding cum"
]
|
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.