SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193448 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193448 [ RunTime:0.003146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868641,995735,117247,597333,641749,746803,33838,112810,347764,54297,684487,671093,499880,356791,550830,803837,833410,389606,448335,57851,936483,1015456,561160,419085,858231,690812,378223,202006,972364,973165,699796,621348,24989,501263,203460,973196,1033178,632664,514762,91062,27941,366308,832919,971417,95018,249398,294005,941667,204686,1005071,388228,185606,622795,737855,329384,448459,627557,39280,829841,1017179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]