SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039709 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039709 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986004,387457,990342,691396,503434,736673,512198,839974,800428,504583,701576,763117,941054,704522,211525,18936,637752,804670,890022,23994,177337,477480,907169,1039794,454556,1042934,709741,204786,690577,256091,282640,274680,819757,644876,834368,179338,698692,306947,329685,877601,246449,975200,906686,677097,932149,54018,503522,269102,63164,455655,561977,181754,200410,837241,707756,760597,689660,84115,133553,680251) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]