SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682039 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682039 [ RunTime:0.004815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51598,1022095,941743,433996,648745,426863,622935,945328,549932,1018095,917133,121660,331058,903816,272527,40096,248138,864581,396399,788660,791807,864099,325915,1010474,224003,352825,461233,816886,963129,81061,158755,790194,1031825,482972,484555,521292,657123,540291,474926,655666,157974,592529,206621,693703,779941,412012,345195,877573,769471,105463,869119,609009,1030574,57487,746240,1047373,1040217,891366,709390,684278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]