Query Metrics
7
Database Queries
7
Different statements
181.01 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.79 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.18 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cock mom"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.19 ms |
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 711674 721137 803058 803246 810675 407872 407698 413130 814354 814610 815402 815424 815438 815612 815660 815686 815701 815923 816089 816918 817856 817858 817862 817925 818417 818420 818429 818441 818632 819048 819709 821565 822458 823068 825210 723588 815321 815894 816498 816659 816724 817939 820131 820714 820738 820833 822470 823017 813693 815342 815500 815691 815790 815813 815859 816207 816414 816482 816532 816550 816794 816928 817093 817216 820039 820379 821273 822308 822499 826430 815145 815443 815551 815700 815726 815942 815993 816074 816336 816367 816564 816806 817324 819472 819486 820525 820726 821293 822065 822121 822280 822587 822879 824789 825274 828539 529663 532770 531972 532633 535806 531665 531674 535653 460827 554976 556801 563263 583867 543711 555658 565035 581284 572450 583015 661056 679708 680049 688052 690874 ] |
||||||||||||||||||||||||||||||
| 4 | 2.82 ms |
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 407698 407872 413130 460827 529663 531665 531674 531972 532633 532770 535653 535806 543711 554976 555658 556801 563263 565035 572450 581284 583015 583867 661056 679708 680049 688052 690874 711674 721137 723588 803058 803246 810675 813693 814354 814610 815145 815321 815342 815402 815424 815438 815443 815500 815551 815612 815660 815686 815691 815700 815701 815726 815790 815813 815859 815894 815923 815942 815993 816074 816089 816207 816336 816367 816414 816482 816498 816532 816550 816564 816659 816724 816794 816806 816918 816928 817093 817216 817324 817856 817858 817862 817925 817939 818417 818420 818429 818441 818632 819048 819472 819486 819709 820039 820131 820379 820525 820714 820726 820738 820833 821273 821293 821565 822065 822121 822280 822308 822458 822470 822499 822587 822879 823017 823068 824789 825210 825274 826430 828539 ] |
||||||||||||||||||||||||||||||
| 5 | 159.42 ms |
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 407698 407872 413130 460827 529663 531665 531674 531972 532633 532770 535653 535806 543711 554976 555658 556801 563263 565035 572450 581284 583015 583867 661056 679708 680049 688052 690874 711674 721137 723588 803058 803246 810675 813693 814354 814610 815145 815321 815342 815402 815424 815438 815443 815500 815551 815612 815660 815686 815691 815700 815701 815726 815790 815813 815859 815894 815923 815942 815993 816074 816089 816207 816336 816367 816414 816482 816498 816532 816550 816564 816659 816724 816794 816806 816918 816928 817093 817216 817324 817856 817858 817862 817925 817939 818417 818420 818429 818441 818632 819048 819472 819486 819709 820039 820131 820379 820525 820714 820726 820738 820833 821273 821293 821565 822065 822121 822280 822308 822458 822470 822499 822587 822879 823017 823068 824789 825210 825274 826430 828539 ] |
||||||||||||||||||||||||||||||
| 6 | 1.95 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cock mom"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.67 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cock mom"
]
|
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.