SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 192017 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 192017 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829259,283194,164539,676489,78848,298411,968888,766008,38280,216967,1013997,454846,936017,450852,112220,790983,765303,228934,301271,859088,88140,775735,257707,345237,434118,540346,210320,393197,789548,783722,8164,479336,848439,617412,984852,361998,430447,270555,118217,74314,268611,995511,223765,1044894,782450,989786,726370,815242,135165,624027,752625,865835,520310,495273,96861,947239,236551,339946,161448,123048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 192017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 192017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]