SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31202 LIMIT 1 [ RunTime:0.003741s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31202 [ RunTime:0.003159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117804,562635,366820,324791,33641,785117,629437,747762,851573,787119,640124,384163,666887,823843,551597,134685,330799,372059,94755,730876,565124,542387,879199,48231,380349,304571,241090,601535,290787,842460,838923,163098,2882,427708,91489,104298,996192,335193,654180,103988,84541,542272,696542,52396,797333,839517,961755,770198,964207,733513,303930,1028610,802236,365932,419753,117469,242536,257355,736150,111850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001099s ]