SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031517 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031517 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470256,357344,918278,790621,993074,260402,964997,925485,309474,87216,9269,93411,512722,739272,424775,655899,924493,1033454,465563,210923,285501,972468,276268,389534,432583,1046261,592416,436241,860729,638003,861706,1017632,857895,907844,531498,629693,146666,897761,47173,390999,2628,932930,1036734,145133,482219,1007999,860384,215460,432377,116788,664767,197385,841039,991794,799121,419457,254495,65657,801262,797703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]