SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329970 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329970 [ RunTime:0.002614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032627,162008,871746,569203,199500,784932,356807,738182,792843,465186,814858,590387,233269,518273,556830,310153,969207,574723,1047068,410889,216004,298624,426879,793015,933450,664581,75180,324025,395859,628807,600068,564134,334461,506200,838835,965999,1047798,570877,425890,223061,767106,322936,151631,601591,19862,877130,71887,146038,898445,722279,392890,1024913,173801,554183,109715,916428,177682,833834,788229,770983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]