SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40204 LIMIT 1 [ RunTime:0.000993s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40204 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (337431,672450,517074,618720,36024,336781,587733,345344,637312,706849,872993,262815,470789,944837,457524,11316,905791,296542,608211,971358,35078,775395,338083,245015,591107,911672,311033,546370,601229,168053,695231,766757,200945,273906,475715,110013,261919,439337,742988,222495,82701,502032,547035,133954,553709,286728,37229,183964,675926,298648,940533,899374,511658,430649,1001636,719591,311556,278777,223063,567922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]