SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005311s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396821 LIMIT 1 [ RunTime:0.001437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396821 [ RunTime:0.005842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201623,509978,865891,83919,430929,379300,87599,244264,196303,1028613,1037870,642309,353762,427456,241236,414609,579994,890958,938669,1010865,237228,199063,668999,172110,584699,847206,588,661760,77258,1002316,1027218,914468,236170,956153,736831,504135,581588,548733,624872,32875,892745,782348,256325,887495,833995,964339,680785,1014534,427159,908746,586803,130189,79011,912778,91189,666672,1038999,485213,709059,19807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002133s ]