SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200 [ RunTime:0.003100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340015,410323,517830,917604,327472,719489,162871,657101,364703,1041891,530289,765497,330827,313996,501598,21896,422370,859167,214428,206275,853609,92605,1031177,322279,712439,855132,1000053,299985,427279,770157,452090,504425,675497,111858,644027,437276,26588,249413,455953,103679,856796,493076,1038682,533249,929617,646679,743992,254302,883600,359419,950036,864083,280992,318740,65839,508331,476384,840923,928065,974769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001033s ]