Query Metrics
7
Database Queries
7
Different statements
431.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.32 ms (48.92%) |
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 383786 396287 412593 414126 414317 417007 417174 421345 435651 442768 446501 451832 452244 452255 453178 454052 455088 460218 465954 472489 472658 474756 475443 478433 480307 482679 487706 488531 492523 493810 494345 496074 499105 502775 503407 504481 515678 515737 518218 520770 521124 522795 524165 525756 527053 527755 528690 530020 530039 530371 530480 530533 530912 531206 531464 532776 532783 532849 532854 532966 532989 533014 533870 534988 536538 540575 544498 545368 549314 550361 556428 557195 558714 559142 568365 568543 574459 589543 591082 591668 592854 594406 594827 598286 598344 599905 600004 600009 600339 601536 603178 604310 604558 610343 614056 623978 628414 629363 630547 631162 631199 632671 633741 633765 636316 637048 639796 640795 644257 646243 651090 675002 689338 690323 717873 718979 720291 724216 726997 756243 ] |
||||||||||||||||||||||||||||||
|
194.71 ms (45.08%) |
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 383786 396287 412593 414126 414317 417007 417174 421345 435651 442768 446501 451832 452244 452255 453178 454052 455088 460218 465954 472489 472658 474756 475443 478433 480307 482679 487706 488531 492523 493810 494345 496074 499105 502775 503407 504481 515678 515737 518218 520770 521124 522795 524165 525756 527053 527755 528690 530020 530039 530371 530480 530533 530912 531206 531464 532776 532783 532849 532854 532966 532989 533014 533870 534988 536538 540575 544498 545368 549314 550361 556428 557195 558714 559142 568365 568543 574459 589543 591082 591668 592854 594406 594827 598286 598344 599905 600004 600009 600339 601536 603178 604310 604558 610343 614056 623978 628414 629363 630547 631162 631199 632671 633741 633765 636316 637048 639796 640795 644257 646243 651090 675002 689338 690323 717873 718979 720291 724216 726997 756243 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (4.30%) |
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 690323 718979 549314 592854 598344 603178 630547 640795 644257 600004 604558 600339 610343 636316 594827 600009 604310 623978 631199 637048 756243 724216 629363 633765 720291 383786 417174 454052 472658 474756 435651 503407 492523 502775 515678 532849 530020 532966 534988 504481 480307 545368 559142 631162 614056 632671 633741 599905 494345 533014 530912 536538 639796 524165 417007 421345 442768 482679 453178 452244 488531 478433 499105 531206 532776 532783 515737 521124 525756 528690 532989 533870 530371 530480 532854 540575 527053 544498 568365 568543 574459 646243 651090 675002 558714 594406 598286 591082 591668 628414 726997 465954 475443 414126 446501 455088 460218 472489 493810 496074 522795 487706 520770 452255 412593 414317 550361 556428 689338 717873 601536 518218 396287 530039 530533 531464 527755 557195 589543 451832 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature casting ass"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature кастинг жоп"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature кастинг жоп"
]
|
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.