SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539912 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539912 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (952300,318768,376289,109593,818804,284907,434561,670250,563703,246140,862706,485017,973398,243597,1040075,801548,518661,836279,183449,551590,736998,208637,664557,765564,145347,805548,684429,807553,214514,389830,393499,934912,811103,150107,403357,330597,363745,579097,575816,371950,787255,405116,918419,435478,378576,481400,503462,7154,509314,334249,769697,623293,845130,107489,471920,301767,700817,1023585,76349,934989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]