SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41525 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41525 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497433,508139,697075,286335,752860,895756,378319,614325,665454,1019102,987431,369356,540543,551010,304663,28308,281161,672283,446428,489685,546796,631896,179506,28847,104778,573697,1007140,1009148,46790,418185,46926,32627,1021855,78278,475595,276598,1025798,512690,365888,907770,73691,106434,914065,272762,308036,1013407,1001889,396702,433533,133660,770241,216103,975296,559922,340567,123658,362297,72965,760480,248723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]