int value = 13;
int base = 2;
int rank = 1;
while (rank*base <= value)
rank *= base;
while (rank) {
printf("%d", value/rank);
value %= rank;
rank /= base;
}Запрос выполняется 8-10 секунд. Причем если меняю GROUP BY CEIL(`timestamp` / 864000) на просто GROUP BY `timestamp`, то запрос выполняется меньше чем за 1 секунду.
SELECT `p`.`id`, `p`.`title`, `p`.`slug`, `p`.`label`, `p`.`price`, `p`.`old_price`, `p`.`category_id`, `p`.`picture_id`, `p`.`brand_id`
FROM `products` AS `p`
LEFT JOIN `brands` AS `b` ON `b`.`id` = `p`.`brand_id`
WHERE `p`.`title` LIKE '%лампа%' OR `b`.`title` LIKE '%лампа%' OR `b`.`tags` like '%лампа%'
GROUP BY `products`.`id` order by `products`.`sales` desc, `products`.`views` desc
LIMIT 18COUNT(DISTINCT `IP`)
SELECT COUNT(DISTINCT `p`.`id`)
FROM `product` AS `p`
JOIN `product_to_category` AS `p2c` ON `p`.`id` = `p2c`.`product_id`
AND `p`.`publish` = 1
AND `p2c`.`category_id` IN (917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 939, 940, 941, 942, 943, 944, 945, 946, 947, 948, 949, 950)
JOIN `city` AS `c` ON `c`.`id` = `p`.`city_id`
AND (`c`.`id` = 108 OR `c`.`parent_id` = 108)if ($day == ($day == 1 && $day <= 5)) { }
elseif ($day == ($day === 6 && $day === 7)) {}
elseif ($day == ($day == 0 && $day > 7)) {}($day == 1 && $day <= 5) выполняется только если $day == 1.($day === 6 && $day === 7) не выполняется никогда.($day == 0 && $day > 7) также не выполняется никогда.switch ($day) {
case 1:
case 2:
case 3:
case 4:
case 5:
echo ... ;
break;
case 6:
case 7:
echo ... ;
break;
default:
echo ... ;
break;
}