SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513616 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513616 [ RunTime:0.003297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201535,313781,952133,710700,915477,962657,960194,85295,224538,280405,892392,932367,534305,160783,311863,858905,139706,88959,594815,1019473,523092,938377,735615,1021439,494004,980863,39145,801560,189147,790534,677844,838118,258742,842377,388069,529204,165221,95151,876349,325462,621359,3285,789848,776466,458416,824759,537665,360554,56852,550755,470462,656582,309158,298661,156724,918327,744847,20576,94887,200261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]