Query Metrics
7
Database Queries
7
Different statements
193.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.15 ms (85.95%) |
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 153869 192968 233707 381991 382239 384752 387021 391669 392605 397421 399654 411329 411375 411628 411767 411933 411947 417080 421501 422299 424429 428368 428829 432081 443328 443692 443756 453145 454257 454559 460759 462557 463157 463221 465342 465634 466350 469493 471054 472105 474382 476716 480792 482389 483090 486894 487315 489661 490202 491647 496036 498822 504793 521040 526507 529183 534258 544504 544769 545926 546935 547873 549135 552309 559009 560392 560485 562975 562993 563152 566810 576398 587133 588295 590303 604102 606704 614514 617190 620201 620612 620619 622381 624859 626138 629847 634858 663982 667630 667899 681293 688624 690899 714199 718496 726489 726502 726505 726538 726689 726902 727465 732074 733884 748239 758299 766016 772123 772459 780704 788881 789711 791361 792660 794804 796090 801173 801226 807953 811005 ] |
||||||||||||||||||||||||||||||
|
15.38 ms (7.96%) |
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 690899 688624 559009 566810 576398 606704 624859 587133 588295 617190 620619 807953 733884 766016 604102 620612 622381 432081 411767 472105 476716 521040 489661 504793 529183 486894 487315 490202 496036 491647 498822 384752 153869 382239 411628 421501 453145 463221 482389 465634 480792 483090 534258 526507 469493 471054 474382 552309 544504 547873 549135 560485 545926 546935 560392 562993 667630 667899 714199 663982 681293 718496 544769 562975 563152 634858 590303 614514 626138 801226 780704 788881 794804 796090 726489 726502 727465 758299 772123 792660 801173 726505 726538 726902 732074 748239 772459 726689 620201 629847 789711 791361 811005 387021 392605 397421 411947 424429 428829 443756 460759 192968 399654 417080 463157 465342 381991 411375 411933 422299 443328 454559 462557 466350 233707 391669 411329 428368 443692 454257 ] |
||||||||||||||||||||||||||||||
|
4.36 ms (2.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old young kissing"
]
|
||||||||||||||||||||||||||||||
|
2.63 ms (1.36%) |
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 153869 192968 233707 381991 382239 384752 387021 391669 392605 397421 399654 411329 411375 411628 411767 411933 411947 417080 421501 422299 424429 428368 428829 432081 443328 443692 443756 453145 454257 454559 460759 462557 463157 463221 465342 465634 466350 469493 471054 472105 474382 476716 480792 482389 483090 486894 487315 489661 490202 491647 496036 498822 504793 521040 526507 529183 534258 544504 544769 545926 546935 547873 549135 552309 559009 560392 560485 562975 562993 563152 566810 576398 587133 588295 590303 604102 606704 614514 617190 620201 620612 620619 622381 624859 626138 629847 634858 663982 667630 667899 681293 688624 690899 714199 718496 726489 726502 726505 726538 726689 726902 727465 732074 733884 748239 758299 766016 772123 772459 780704 788881 789711 791361 792660 794804 796090 801173 801226 807953 811005 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old young kissing"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old young kissing"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.