SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331218 LIMIT 1 [ RunTime:0.001179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331218 [ RunTime:0.004201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270183,302975,660861,946312,118560,501195,46460,786098,149232,240927,3550,409810,964288,429561,486826,791847,369450,673358,180152,750555,1004890,841243,896194,21590,587228,507971,550534,407114,1019872,66581,792446,665478,380563,81160,547867,682940,654897,724077,872013,123163,320902,206748,122441,711230,534189,88858,937168,63062,93066,918108,435519,394139,311683,465027,359180,680943,538941,137020,171372,823015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]