SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351791 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351791 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691883,455563,118582,441894,944996,943448,436642,585367,292702,694096,18226,754759,426528,48587,10448,596554,239576,41391,66338,977724,958647,964443,582868,436094,171518,965573,450484,724197,528572,779404,883152,35210,1012450,484983,684558,419538,740966,551809,682105,122792,162867,1017639,407106,303659,1020907,303543,780151,674236,372242,836933,133855,133137,746593,57407,176172,305355,485608,776491,954240,524082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]