SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302010 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302010 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656877,34464,536181,33621,202021,812200,318039,666837,1027971,492644,886427,821481,338772,709842,605971,449306,57800,324972,573208,596078,869373,209095,204333,97612,545435,70513,433550,452586,756313,584757,957605,693486,685787,826718,659133,257198,127876,14595,885074,701386,123358,978214,819480,480099,196392,712827,322211,509237,834822,996492,515263,492927,77885,436490,430194,844988,403085,55033,824255,636554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]