SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415520 LIMIT 1 [ RunTime:0.000615s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415520 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019332,906719,92185,462460,632509,861935,290975,480835,249056,1043519,638034,707120,142733,920119,827520,1046049,464555,576951,628762,4631,22380,241844,830747,644816,947635,252757,168558,722398,172015,965680,413610,236607,653074,472485,938776,409154,198009,60078,497886,376801,111857,490933,861298,901758,163449,803016,790350,488326,560099,84780,490225,933543,346180,867843,2325,30220,58409,363655,709680,605208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]