SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511974 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511974 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379331,281915,191546,581253,793071,985003,702324,243168,1010465,344614,947546,4944,685068,684085,72711,930739,390398,436592,26469,989116,564918,288255,877348,973265,74001,336467,802458,74384,658858,157857,873166,704538,63716,716928,99998,467615,1046685,92882,914521,971164,695723,289122,778700,824823,192304,492105,784271,440026,52128,142365,789112,778572,322631,140483,493800,79964,152295,253059,107472,992417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]