SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199535 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199535 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315120,655305,57899,353878,651925,218110,1026911,350485,323793,445779,118099,697255,1045401,21737,449647,880382,432017,880527,321827,719238,661493,51490,597349,91484,1026673,161140,766490,986956,329048,476317,649379,873573,701071,522583,457401,352682,144361,23550,895121,633616,1015235,950457,89127,133830,569982,299532,651739,93318,523227,263602,239526,615058,486260,226167,795533,1041419,434336,808344,769102,961013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]