SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476180 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476180 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60098,1039390,952710,699917,117818,194580,783772,703853,7183,684825,765855,661588,778715,185800,489457,510851,1027895,790117,1032585,920650,310600,286357,984862,88136,838289,49087,532762,580801,145368,43501,731032,1020534,789028,236142,454586,311910,415200,302260,501652,376776,82510,990531,30448,274126,6752,847959,477350,554615,840080,637366,124700,1003739,322640,73935,546374,251549,339139,990543,594983,594269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]