Query Metrics
7
Database Queries
7
Different statements
195.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.54 ms (85.19%) |
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 96205 187843 388543 389757 392754 395889 397850 397863 397916 398559 398954 401006 401821 404491 411321 411356 411820 411986 424436 428112 428142 439722 439758 439778 439824 439856 441910 442814 442997 443177 444104 444917 446119 451445 452651 453072 453153 454156 454166 454179 454224 454249 454271 454430 454437 454440 454558 454563 454567 457462 459951 460607 461322 462602 463177 465535 466085 466228 466722 466875 466877 469390 472119 472652 472699 473249 474094 475883 476230 476287 479059 482368 486024 486798 487321 489938 490438 493104 495499 496028 498491 502024 502062 507041 508575 510864 512997 513581 514761 514818 515964 522472 526738 527424 534258 559066 569298 571828 582444 584243 584395 590503 609083 619614 622693 665110 680290 713122 714889 724475 728308 742739 759117 768387 778563 781824 797241 797468 824258 826267 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (9.55%) |
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 713122 680290 778563 781824 759117 724475 728308 768387 742739 714889 465535 398954 388543 495499 622693 96205 397863 454437 460607 466722 454430 489938 482368 665110 584243 590503 619614 797468 424436 442997 451445 469390 473249 479059 411321 439758 439856 454156 454166 466228 466875 475883 397850 428142 439722 454567 466877 392754 397916 398559 401006 439778 439824 442814 454179 454224 454249 454271 454558 463177 411356 454563 466085 490438 496028 487321 493104 526738 498491 454440 476230 582444 569298 571828 609083 797241 452651 472119 444917 486024 527424 187843 395889 389757 401821 404491 411986 444104 441910 443177 411820 428112 826267 824258 446119 461322 486798 453072 453153 472699 457462 462602 476287 502024 510864 522472 502062 507041 512997 514761 514818 515964 534258 513581 508575 459951 472652 474094 584395 559066 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.39%) |
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 96205 187843 388543 389757 392754 395889 397850 397863 397916 398559 398954 401006 401821 404491 411321 411356 411820 411986 424436 428112 428142 439722 439758 439778 439824 439856 441910 442814 442997 443177 444104 444917 446119 451445 452651 453072 453153 454156 454166 454179 454224 454249 454271 454430 454437 454440 454558 454563 454567 457462 459951 460607 461322 462602 463177 465535 466085 466228 466722 466875 466877 469390 472119 472652 472699 473249 474094 475883 476230 476287 479059 482368 486024 486798 487321 489938 490438 493104 495499 496028 498491 502024 502062 507041 508575 510864 512997 513581 514761 514818 515964 522472 526738 527424 534258 559066 569298 571828 582444 584243 584395 590503 609083 619614 622693 665110 680290 713122 714889 724475 728308 742739 759117 768387 778563 781824 797241 797468 824258 826267 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby milf mature"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby milf mature"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby milf 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.