SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195083 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195083 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45181,301832,823704,140384,682430,877730,191775,995270,203219,520199,500651,554655,140352,540470,762870,876190,901457,645522,179601,495213,1023934,348284,1016979,762253,639497,214407,900290,616087,495531,280537,579739,25976,995969,261970,878501,123743,598169,998382,923353,138041,221655,3429,441699,772303,660110,841980,501996,960742,445035,174102,760251,627881,290756,418756,706484,270023,614752,123527,104473,231525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002498s ]