SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475034 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475034 [ RunTime:0.005698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378940,861042,705993,2846,696268,734479,532091,136459,674567,150298,298749,952239,448148,543475,917210,968840,232251,782917,1007192,811253,546391,469627,132123,27072,34611,179761,765231,743474,930189,352019,85142,856463,596175,227170,572540,491061,899099,796675,578951,108522,980265,361582,562299,791906,701644,299381,93958,356637,90868,904648,615714,201150,362841,503435,705236,501740,427454,551769,357842,122313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]