SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408513 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408513 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (346051,149918,952691,282830,16622,820739,579270,672584,195178,169033,365840,7900,643839,758179,150097,614063,667897,184010,441132,219992,213672,554592,53121,729154,744779,856211,973990,177782,410532,391726,762333,39936,406752,721853,457256,734578,687192,373807,831333,414397,67273,184291,903811,453809,420277,133783,914911,856127,681263,934513,634189,897194,132341,70634,318725,221043,402377,647421,1035370,953559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]