SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485611 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485611 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645992,408681,13554,816486,275301,209566,822728,815906,1011875,268634,268288,72503,511061,538476,493235,842564,395979,906600,698350,943181,677429,441948,1023713,396642,716530,6026,199593,766807,993887,450413,90453,853126,405363,21398,682611,125393,832811,497142,303447,1025165,380416,6783,298104,775450,369936,470738,197150,1027304,1032134,991627,563873,115586,113756,351681,696980,31730,597292,99451,12153,423280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]