SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43113 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43113 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042531,364816,972179,929127,225480,581149,629880,1019513,1002637,180932,1021760,655364,842922,465242,651529,318640,400484,794149,478809,705094,713419,256984,1043592,567662,371436,47112,92092,135648,638792,709357,369901,1000722,1038456,232170,957875,101251,998612,661065,191926,978378,950809,348677,366013,48321,215361,323417,392588,679867,914462,176088,663889,536827,819483,857124,861292,905467,978460,452858,402903,960439) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]