Query Metrics
7
Database Queries
7
Different statements
178.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.51 ms (87.50%) |
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 210768 388436 406688 406881 408472 409143 422488 424153 428334 429901 440890 444928 445930 446534 447656 448375 453773 456530 457776 458013 469644 470273 471664 474283 474969 477742 478088 478464 478774 478998 493571 513484 535508 536849 537393 540478 542173 551164 556474 558718 568251 569981 576671 577381 599400 612039 614434 619012 620051 620234 621315 626291 626292 628171 630279 630435 631187 633238 642697 644296 659009 662916 664193 672145 685479 686152 690865 693051 693342 694222 695993 703547 706930 707497 708462 712567 714036 717834 720444 720445 721103 722190 722212 723549 726877 735130 755030 761155 761193 763396 770532 773907 784419 784567 788030 792246 793182 794331 794791 799002 799362 805935 806057 807994 810769 812979 814434 815071 815142 815165 815740 816602 817169 818828 819119 819490 821688 822606 823584 826020 ] |
||||||||||||||||||||||||||||||
|
13.45 ms (7.52%) |
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 620234 626291 626292 642697 644296 703547 708462 717834 784419 793182 799002 799362 807994 810769 424153 456530 474969 493571 388436 406881 440890 469644 445930 457776 478088 577381 714036 630435 806057 784567 788030 812979 444928 478464 471664 474283 422488 470273 614434 458013 599400 540478 662916 628171 817169 723549 816602 819119 823584 826020 815071 815165 819490 815142 818828 535508 537393 542173 558718 576671 659009 693051 694222 712567 720444 722212 672145 686152 690865 695993 706930 720445 722190 568251 633238 630279 631187 792246 773907 805935 735130 761155 761193 763396 770532 707497 794331 428334 814434 478774 551164 721103 429901 569981 619012 612039 448375 446534 477742 453773 447656 685479 409143 210768 513484 556474 755030 478998 406688 408472 821688 815740 822606 536849 693342 664193 620051 621315 794791 726877 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.59%) |
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 210768 388436 406688 406881 408472 409143 422488 424153 428334 429901 440890 444928 445930 446534 447656 448375 453773 456530 457776 458013 469644 470273 471664 474283 474969 477742 478088 478464 478774 478998 493571 513484 535508 536849 537393 540478 542173 551164 556474 558718 568251 569981 576671 577381 599400 612039 614434 619012 620051 620234 621315 626291 626292 628171 630279 630435 631187 633238 642697 644296 659009 662916 664193 672145 685479 686152 690865 693051 693342 694222 695993 703547 706930 707497 708462 712567 714036 717834 720444 720445 721103 722190 722212 723549 726877 735130 755030 761155 761193 763396 770532 773907 784419 784567 788030 792246 793182 794331 794791 799002 799362 805935 806057 807994 810769 812979 814434 815071 815142 815165 815740 816602 817169 818828 819119 819490 821688 822606 823584 826020 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public pickups anal"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на pickups улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на pickups улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.71%) |
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.