SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 69 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 69 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381611,106627,181618,877174,743368,185089,709258,899853,624157,484720,291833,300966,214185,785492,107075,751440,611159,19493,66606,703372,981454,307384,897749,1032911,154491,578515,128113,941200,123001,483981,985447,860196,79073,766730,805343,635304,827711,195588,427433,362184,236236,792171,742498,476697,881582,814256,698777,154301,465178,910937,889393,32882,204453,462686,1028359,695540,979229,597277,332756,353847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 69 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 69 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]