Query Metrics
7
Database Queries
7
Different statements
173.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.04 ms (82.26%) |
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 383400 407252 411361 463757 464139 464328 466963 469355 469534 470214 473505 475249 475630 476079 476907 477230 477335 477867 481507 481881 482346 482507 484634 485313 486470 486678 487514 489112 491023 491208 491955 492602 493204 495199 495393 499882 500905 501497 502512 502928 504841 506429 506884 507663 508451 509164 510299 510425 511564 512059 513845 514070 515544 516842 516904 517000 517743 519023 519588 520311 522013 523027 525116 525118 526218 527447 527990 528089 528153 531420 531425 531511 531513 531516 531920 532685 532755 535016 537789 541244 541630 541631 541833 541877 542188 542189 542594 550434 551069 554905 556427 557064 557169 557312 559233 562879 563865 565783 568061 571806 573393 580215 590872 593499 601119 604161 605914 605963 614789 624201 636315 643364 675006 682545 741770 743780 759808 782154 797261 801096 ] |
||||||||||||||||||||||||||||||
|
21.70 ms (12.48%) |
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 482507 477335 531516 531513 531425 557064 557169 551069 682545 556427 557312 563865 624201 528153 509164 469534 504841 531511 520311 531420 532685 541630 541833 541244 571806 675006 568061 590872 643364 466963 475249 519588 527447 492602 523027 516904 525116 525118 528089 743780 562879 481507 491208 493204 511564 541877 554905 476079 487514 515544 573393 593499 477867 485313 508451 535016 464139 532755 517743 463757 501497 741770 542188 601119 604161 482346 506429 510299 537789 486678 491955 473505 517000 383400 512059 531920 542189 469355 476907 407252 481881 489112 495393 502512 513845 526218 527990 550434 491023 506884 464328 502928 477230 541631 507663 484634 542594 636315 519023 495199 514070 565783 522013 411361 516842 475630 499882 470214 559233 580215 510425 782154 759808 486470 797261 801096 500905 605914 605963 614789 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.28%) |
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 383400 407252 411361 463757 464139 464328 466963 469355 469534 470214 473505 475249 475630 476079 476907 477230 477335 477867 481507 481881 482346 482507 484634 485313 486470 486678 487514 489112 491023 491208 491955 492602 493204 495199 495393 499882 500905 501497 502512 502928 504841 506429 506884 507663 508451 509164 510299 510425 511564 512059 513845 514070 515544 516842 516904 517000 517743 519023 519588 520311 522013 523027 525116 525118 526218 527447 527990 528089 528153 531420 531425 531511 531513 531516 531920 532685 532755 535016 537789 541244 541630 541631 541833 541877 542188 542189 542594 550434 551069 554905 556427 557064 557169 557312 559233 562879 563865 565783 568061 571806 573393 580215 590872 593499 601119 604161 605914 605963 614789 624201 636315 643364 675006 682545 741770 743780 759808 782154 797261 801096 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature красивая"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.70%) |
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.