SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486198 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486198 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413896,893312,486092,904120,798893,573636,319401,98183,596031,339244,455692,326676,410195,191832,542804,358083,797245,405701,299906,712073,316706,132103,547434,430187,137070,957295,504752,542208,63259,486292,336664,694149,867783,272079,670206,820093,720476,1014276,416344,33160,505174,37952,807305,163035,139814,959408,298346,477364,1010781,880251,721898,930712,8317,664863,485874,555529,16767,909194,987314,893113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]