SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900180 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900180 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646580,281002,655730,932237,1020831,793891,528649,433916,1040267,167522,1431,400163,971743,624537,877033,28436,445812,122041,883711,866689,918741,756670,124494,49862,544889,166706,142156,249630,1040528,23490,324515,670788,129969,331456,330284,600612,960280,685289,832493,751710,796242,788093,5242,20450,487870,794052,435993,474249,62065,784969,717070,946970,449593,462954,139668,931480,925801,1018006,655982,158461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]