Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "interracial teen orgy"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'interracial teen orgy' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  672159
  409452
  775934
  537186
  719857
  423654
  777064
  806377
  454122
  488721
  537929
  637025
  775758
  804469
  407290
  517864
  497557
  414342
  429766
  493235
  544854
  578376
  679785
  401904
  500431
  408460
  681691
  680167
  429793
  536580
  556051
  677783
  651666
  33459
  820779
  522133
  645238
  535631
  676634
  485149
  506143
  674953
  646450
  647635
  605374
  634778
  716902
  518490
  679801
  522147
  563535
  648837
  650198
  701348
  605449
  451256
  644913
  532645
  676022
  677307
  507880
  624270
  532680
  531187
  556741
  639732
  617427
  531105
  528361
  674994
  532666
  632563
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (672159, 409452, 775934, 537186, 719857, 423654, 777064, 806377, 454122, 488721, 537929, 637025, 775758, 804469, 407290, 517864, 497557, 414342, 429766, 493235, 544854, 578376, 679785, 401904, 500431, 408460, 681691, 680167, 429793, 536580, 556051, 677783, 651666, 33459, 820779, 522133, 645238, 535631, 676634, 485149, 506143, 674953, 646450, 647635, 605374, 634778, 716902, 518490, 679801, 522147, 563535, 648837, 650198, 701348, 605449, 451256, 644913, 532645, 676022, 677307, 507880, 624270, 532680, 531187, 556741, 639732, 617427, 531105, 528361, 674994, 532666, 632563);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  33459
  401904
  407290
  408460
  409452
  414342
  423654
  429766
  429793
  451256
  454122
  485149
  488721
  493235
  497557
  500431
  506143
  507880
  517864
  518490
  522133
  522147
  528361
  531105
  531187
  532645
  532666
  532680
  535631
  536580
  537186
  537929
  544854
  556051
  556741
  563535
  578376
  605374
  605449
  617427
  624270
  632563
  634778
  637025
  639732
  644913
  645238
  646450
  647635
  648837
  650198
  651666
  672159
  674953
  674994
  676022
  676634
  677307
  677783
  679785
  679801
  680167
  681691
  701348
  716902
  719857
  775758
  775934
  777064
  804469
  806377
  820779
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (33459, 401904, 407290, 408460, 409452, 414342, 423654, 429766, 429793, 451256, 454122, 485149, 488721, 493235, 497557, 500431, 506143, 507880, 517864, 518490, 522133, 522147, 528361, 531105, 531187, 532645, 532666, 532680, 535631, 536580, 537186, 537929, 544854, 556051, 556741, 563535, 578376, 605374, 605449, 617427, 624270, 632563, 634778, 637025, 639732, 644913, 645238, 646450, 647635, 648837, 650198, 651666, 672159, 674953, 674994, 676022, 676634, 677307, 677783, 679785, 679801, 680167, 681691, 701348, 716902, 719857, 775758, 775934, 777064, 804469, 806377, 820779);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  33459
  401904
  407290
  408460
  409452
  414342
  423654
  429766
  429793
  451256
  454122
  485149
  488721
  493235
  497557
  500431
  506143
  507880
  517864
  518490
  522133
  522147
  528361
  531105
  531187
  532645
  532666
  532680
  535631
  536580
  537186
  537929
  544854
  556051
  556741
  563535
  578376
  605374
  605449
  617427
  624270
  632563
  634778
  637025
  639732
  644913
  645238
  646450
  647635
  648837
  650198
  651666
  672159
  674953
  674994
  676022
  676634
  677307
  677783
  679785
  679801
  680167
  681691
  701348
  716902
  719857
  775758
  775934
  777064
  804469
  806377
  820779
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (33459, 401904, 407290, 408460, 409452, 414342, 423654, 429766, 429793, 451256, 454122, 485149, 488721, 493235, 497557, 500431, 506143, 507880, 517864, 518490, 522133, 522147, 528361, 531105, 531187, 532645, 532666, 532680, 535631, 536580, 537186, 537929, 544854, 556051, 556741, 563535, 578376, 605374, 605449, 617427, 624270, 632563, 634778, 637025, 639732, 644913, 645238, 646450, 647635, 648837, 650198, 651666, 672159, 674953, 674994, 676022, 676634, 677307, 677783, 679785, 679801, 680167, 681691, 701348, 716902, 719857, 775758, 775934, 777064, 804469, 806377, 820779);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "межрасов teen orgy"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'межрасов teen orgy';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "межрасов teen orgy"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'межрасов teen orgy';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "interracial teen orgy"
  "interracial teen orgy"
  "interracial teen orgy"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('interracial teen orgy') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('interracial teen orgy')
              AND `query` <> 'interracial teen orgy'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;