SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343014 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343014 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175247,862114,985289,943627,1015350,136495,743795,450966,687287,814845,204614,415075,200375,180885,335090,853347,717929,438367,290978,624108,203897,894996,205656,442848,298996,747084,1036180,802994,462887,962247,472450,26315,190074,964096,363549,632875,372579,476676,523555,458715,914327,485019,210174,181217,96347,128017,656254,750839,343885,196460,961877,1000191,444784,620071,739245,781679,421430,892370,347131,784261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]