SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856199 LIMIT 1 [ RunTime:0.002167s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856199 [ RunTime:0.004156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134388,195020,109317,1001074,508546,750430,181410,145843,110074,341301,1013120,727262,244008,576926,1030499,555653,662939,254905,635619,91806,144713,169801,202927,413623,342953,798200,710591,641182,268270,217168,465903,812269,1002289,424163,116894,807871,257761,146531,658199,335941,103887,749056,392777,499258,226860,684874,915173,954961,590390,734940,923304,703797,10225,286185,553000,363514,550837,253684,192666,354671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]