SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199004 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199004 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512709,509447,157432,515249,690802,235442,101817,689238,113158,1027089,951846,698998,601256,24678,760346,471315,520347,238235,1032062,656506,570700,1018432,293292,691877,1028836,629014,907929,234893,1044215,657995,245490,76049,797972,963789,362064,391371,599217,65603,348341,253269,566844,486585,1032264,384256,932980,871460,883542,22483,882984,391233,67994,248624,837867,719071,781967,999665,483694,692946,411756,98308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]