Query Metrics
7
Database Queries
7
Different statements
163.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.67 ms (84.70%) |
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 79 3786 61536 152440 335978 356378 383247 386102 397392 400516 412294 413648 413702 416342 428793 437325 442443 448358 450116 450147 453382 453400 454484 456578 456717 457577 464056 474833 482481 490453 500094 516005 523400 525361 528526 529679 533843 536447 543297 544978 545247 547981 552062 554408 554439 554836 556771 557097 561507 562604 565323 574257 577185 579693 579809 588345 589677 593006 593118 599765 602119 603417 603664 604999 606056 610246 619327 629807 635615 636426 646721 664528 664594 704542 714374 714388 722322 725130 725492 727977 733131 739576 739926 742507 744388 746111 746170 747056 747068 752482 755060 761842 761854 762177 768384 781926 792538 793493 794108 795815 795828 795942 796251 796793 808234 810064 811271 820374 823767 824699 824963 826204 826209 826287 826615 827285 827712 828310 828604 828765 ] |
||||||||||||||||||||||||||||||
|
15.08 ms (9.21%) |
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 545247 552062 554408 619327 811271 437325 823767 739926 761842 761854 474833 490453 413648 450147 464056 557097 603417 603664 442443 528526 413702 456578 561507 725492 428793 457577 635615 725130 383247 152440 335978 3786 79 826209 827285 827712 820374 824963 826204 826615 824699 826287 828310 828765 828604 500094 523400 525361 533843 529679 536447 543297 577185 544978 547981 579809 664528 714388 554836 565323 593006 599765 629807 610246 602119 593118 781926 792538 795815 808234 733131 746111 810064 762177 739576 744388 746170 747056 747068 768384 727977 755060 704542 793493 795828 796251 795942 416342 794108 579693 588345 453400 516005 554439 574257 604999 412294 456717 742507 356378 664594 722322 636426 562604 556771 606056 386102 61536 482481 448358 450116 453382 454484 646721 714374 589677 796793 752482 397392 400516 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.77%) |
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 79 3786 61536 152440 335978 356378 383247 386102 397392 400516 412294 413648 413702 416342 428793 437325 442443 448358 450116 450147 453382 453400 454484 456578 456717 457577 464056 474833 482481 490453 500094 516005 523400 525361 528526 529679 533843 536447 543297 544978 545247 547981 552062 554408 554439 554836 556771 557097 561507 562604 565323 574257 577185 579693 579809 588345 589677 593006 593118 599765 602119 603417 603664 604999 606056 610246 619327 629807 635615 636426 646721 664528 664594 704542 714374 714388 722322 725130 725492 727977 733131 739576 739926 742507 744388 746111 746170 747056 747068 752482 755060 761842 761854 762177 768384 781926 792538 793493 794108 795815 795828 795942 796251 796793 808234 810064 811271 820374 823767 824699 824963 826204 826209 826287 826615 827285 827712 828310 828604 828765 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby panties"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby трусик нижн бел"
]
|
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.