SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447483 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447483 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382415,136874,783066,582906,324407,1033554,26681,629664,373540,539618,782889,73696,1044613,766113,122299,582098,828074,713178,907727,725798,327303,726237,622147,912188,779098,925849,183038,996452,869412,188205,402073,432889,725893,414637,612962,460500,92447,421804,655015,169060,687490,312713,684046,29421,406540,221294,303320,791433,781190,350386,836461,749609,55733,725270,864171,866310,659701,324178,490438,138562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]