SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45203 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45203 [ RunTime:0.002292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295325,307582,240252,667708,211952,335301,435863,988964,67429,270251,12719,269626,194447,413288,988599,295053,560800,662113,449460,1442,467431,845977,644658,715667,636627,266503,255160,606357,238540,796968,788276,762167,354128,396241,491743,909634,955241,143607,317013,764895,386007,385115,583823,1037175,750518,856157,428959,429352,1013958,744789,385943,20616,833095,513278,178637,65730,170181,126708,734021,694528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]