Query Metrics
7
Database Queries
7
Different statements
143.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.47 ms (82.76%) |
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 406391 411984 413164 416117 424686 424883 425015 433921 438369 441442 442451 444637 444742 445919 446373 446849 447494 447825 448229 448284 448487 449206 449468 450813 451226 451328 452218 453908 454372 455028 455171 455486 456103 456410 457306 458474 462624 463743 464067 464128 467690 469449 469568 470208 472052 473690 475041 476141 476567 476632 478140 478247 479253 479752 481523 483882 486437 488137 489101 496374 500441 503076 505963 506126 506855 510174 511161 511900 512140 513596 513932 514273 515610 515614 516208 516418 516670 518850 525409 528601 529174 531538 531543 540282 545455 553430 560690 561386 562597 565453 567536 569241 571232 576680 578234 584745 585767 586644 586986 588258 598138 598348 601309 607696 610343 619738 622364 625541 676987 730465 756377 756966 770928 778069 779736 797680 811724 812989 813185 ] |
||||||||||||||||||||||||||||||
|
14.98 ms (10.47%) |
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 601309 448284 411984 463743 475041 450813 531543 472052 478140 476567 510174 479752 425015 456410 452218 489101 505963 506126 584745 553430 578234 607696 470208 438369 445919 514273 486437 503076 512140 518850 528601 449206 467690 479253 424686 424883 413164 464128 513596 529174 540282 516418 622364 778069 797680 812989 756966 730465 464067 406391 488137 473690 484232 576680 571232 586986 756377 433921 476141 448487 447494 598138 478247 511900 462624 516208 610343 483882 515614 454372 525409 588258 453908 455028 455486 456103 511161 513932 516670 447825 451226 565453 458474 444637 448229 476632 586644 455171 496374 500441 531538 562597 441442 416117 676987 446849 515610 469449 481523 506855 444742 561386 779736 469568 446373 545455 569241 811724 770928 567536 813185 449468 451328 598348 442451 560690 585767 619738 625541 457306 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.73%) |
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 406391 411984 413164 416117 424686 424883 425015 433921 438369 441442 442451 444637 444742 445919 446373 446849 447494 447825 448229 448284 448487 449206 449468 450813 451226 451328 452218 453908 454372 455028 455171 455486 456103 456410 457306 458474 462624 463743 464067 464128 467690 469449 469568 470208 472052 473690 475041 476141 476567 476632 478140 478247 479253 479752 481523 483882 486437 488137 489101 496374 500441 503076 505963 506126 506855 510174 511161 511900 512140 513596 513932 514273 515610 515614 516208 516418 516670 518850 525409 528601 529174 531538 531543 540282 545455 553430 560690 561386 562597 565453 567536 569241 571232 576680 578234 584745 585767 586644 586986 588258 598138 598348 601309 607696 610343 619738 622364 625541 676987 730465 756377 756966 770928 778069 779736 797680 811724 812989 813185 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big but panties"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие трусик нижн бел"
]
|
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.