SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203440 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203440 [ RunTime:0.002208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121206,683710,527291,631689,211645,918787,365933,704366,510469,918166,138934,708988,286085,622812,826984,1015990,535325,958014,989675,519209,908611,284418,877639,415359,628498,539430,693464,715017,517059,501445,868407,833948,559654,16357,93828,174511,340796,584523,1042194,494312,501609,759537,700262,859251,139945,55487,10460,668491,580901,863644,461416,34885,375437,449101,988222,181296,143862,652062,440864,964898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]