Query Metrics
7
Database Queries
7
Different statements
366.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.41 ms (57.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
132.08 ms (36.02%) |
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 155232 182135 282038 383290 383780 384397 388642 410310 413789 415571 423307 426470 428874 428888 430508 431794 444731 445083 448266 451694 453226 455915 460598 474876 487013 488933 492246 493470 501703 502832 502894 505024 506945 509643 510890 511302 511670 521267 530050 530183 531544 531899 534354 534764 535372 535543 536528 536559 537311 537857 538076 541106 546149 552881 552989 553430 563267 566164 574708 577408 580866 582595 583199 587120 587206 587445 589234 592164 593245 593666 597177 601024 612265 613152 614990 622366 623934 624426 624497 625435 628343 631750 631802 641807 646022 646435 651693 666658 668292 673772 684731 707483 708517 715688 716181 724241 724426 724437 724527 732293 732377 733398 744919 748155 755165 770964 779464 788166 791961 799409 802416 804445 806959 807402 807991 808068 808135 808740 813388 827290 ] |
||||||||||||||||||||||||||||||
|
15.05 ms (4.11%) |
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 587445 808740 715688 799409 804445 716181 807402 808135 546149 592164 384397 445083 451694 537857 488933 707483 577408 813388 808068 779464 807991 428874 474876 426470 431794 553430 502894 624497 415571 413789 531899 593666 724241 492246 448266 614990 589234 748155 732293 755165 423307 388642 536559 552881 612265 587206 624426 628343 587120 535372 534764 631750 455915 724437 536528 791961 802416 788166 724426 744919 806959 428888 535543 583199 582595 666658 646022 601024 622366 537311 574708 444731 501703 531544 566164 580866 641807 430508 509643 538076 733398 530050 453226 506945 673772 631802 732377 460598 510890 282038 410310 827290 668292 684731 613152 625435 597177 770964 155232 383780 182135 487013 511670 530183 493470 541106 383290 505024 511302 521267 502832 534354 646435 708517 651693 552989 563267 623934 593245 724527 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (0.98%) |
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 155232 182135 282038 383290 383780 384397 388642 410310 413789 415571 423307 426470 428874 428888 430508 431794 444731 445083 448266 451694 453226 455915 460598 474876 487013 488933 492246 493470 501703 502832 502894 505024 506945 509643 510890 511302 511670 521267 530050 530183 531544 531899 534354 534764 535372 535543 536528 536559 537311 537857 538076 541106 546149 552881 552989 553430 563267 566164 574708 577408 580866 582595 583199 587120 587206 587445 589234 592164 593245 593666 597177 601024 612265 613152 614990 622366 623934 624426 624497 625435 628343 631750 631802 641807 646022 646435 651693 666658 668292 673772 684731 707483 708517 715688 716181 724241 724426 724437 724527 732293 732377 733398 744919 748155 755165 770964 779464 788166 791961 799409 802416 804445 806959 807402 807991 808068 808135 808740 813388 827290 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big huge tits"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие огромные сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.43%) |
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.