SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402018 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402018 [ RunTime:0.002329s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699814,293943,550875,994977,718670,277269,393498,472368,58484,848230,841410,112699,100167,32249,531385,437442,595498,118897,181105,892428,245372,1039863,734541,513329,543811,854127,240817,711455,937863,831434,596391,867715,640595,189744,774258,485759,590272,1023750,566990,1007698,489864,69573,16692,430628,881391,142971,7946,587921,357986,334396,256246,836132,865567,833034,1019006,277945,893839,590571,935167,859368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]