SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508327 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508327 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422487,824280,731030,284920,70729,319285,5227,404090,245211,328598,956968,805811,937952,522619,492297,546607,393368,679507,847551,164848,771059,29270,484462,869434,345401,318447,998694,180783,537245,939443,209027,66703,169341,504094,314753,800319,644944,581717,47730,148415,565445,583981,864105,371954,364284,483435,19656,935387,544081,860075,338975,403049,357471,621717,187106,16041,6028,84529,369327,674546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]