SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284778 LIMIT 1 [ RunTime:0.001238s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284778 [ RunTime:0.003514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9136,969734,592614,142751,500831,152021,324410,1045412,741123,90201,94841,1047203,83014,701017,808805,62307,769608,626417,418587,614813,1022900,571477,323373,113531,871386,10735,378603,596795,1019408,418255,326011,421647,628392,136194,980919,2651,944616,445824,905244,890791,116766,304477,617919,951818,865311,86222,740888,958239,118885,868574,69841,583869,957935,133273,624498,363513,69208,776813,598022,749289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]