SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006006 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006006 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261202,430855,957499,899144,332174,20460,513131,700037,790537,664604,942243,914438,1022155,734764,129397,829119,432628,629338,314657,628376,442672,48088,26352,291959,42312,830396,945665,648182,265494,578315,963463,393991,353564,906112,205242,1027574,1047246,371643,297677,348140,508417,643665,537468,494170,103334,650975,171138,222919,193770,374895,339102,76560,934687,806928,623356,722367,915753,54867,56709,286232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]