SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342018 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342018 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387345,278686,219756,829591,10670,682884,807712,960546,596979,862657,737390,808473,553998,309432,949315,779436,730002,205760,260910,893400,349508,951085,344135,904165,1978,693362,693196,510439,143306,289060,17368,72154,249877,179468,269189,138341,609479,861013,82179,298630,511858,292405,785572,540923,822208,405733,391901,673854,541702,763741,449526,676855,765613,229513,171861,500551,986814,307556,86885,462400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]