SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343035 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343035 [ RunTime:0.007320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008438,525791,844380,199115,66967,93666,383453,132783,555858,786090,983605,613675,933909,47965,87815,592402,745450,258599,632938,152198,410762,186216,949153,88069,853030,676237,793452,4564,589623,89072,879115,944335,690049,985406,906858,456982,944084,533901,397164,639969,816542,529174,653417,284940,350638,201762,113677,344583,369956,689907,452626,1032874,757645,580321,481218,397799,523072,774529,1027918,184941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000984s ]