SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035981 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035981 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298392,159676,768515,613664,540426,428300,277494,468263,604097,914908,692970,403520,335893,949323,954447,208544,359491,499681,699371,200145,6719,673201,547196,824511,868610,917640,26165,269580,336169,892567,668293,963497,591232,838000,354888,324236,230032,380099,956449,664454,342970,491524,874148,721550,997947,590779,512966,312124,189672,784194,1005781,410199,501630,962794,25400,680913,31161,181048,823027,520963) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]