SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002988s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 79180 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 79180 [ RunTime:0.003760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018010,180451,376013,856930,446393,594733,846183,627944,311002,747743,1002896,561346,78275,941571,1020919,214348,993479,806941,788847,18317,529056,608822,813170,908809,82427,732672,126140,61942,901161,976783,56792,944922,111291,716824,547890,988719,219848,36510,918148,711982,789582,495028,36922,1036521,675809,546337,1024517,969627,340495,57060,483693,314851,91985,735508,164529,615585,932612,470806,752801,741670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 79180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 79180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]