SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39110 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39110 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839317,869052,414767,821416,63389,522875,185250,361233,684755,155895,639912,865017,266427,844090,529690,68340,151340,885348,80766,311219,270862,62198,673194,979751,489127,138536,845253,6930,634560,256398,494267,448024,662872,528310,869752,21883,621079,765771,847465,573181,593418,673295,696998,918567,1045285,529692,501072,690734,1039411,361950,134757,502537,789645,367214,825309,252684,94755,583925,143024,908428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]