SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502701 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502701 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302085,355841,861093,29067,572885,538655,524708,1008134,124996,761472,808789,625697,797663,446416,1027861,1014938,761017,41628,465112,544088,556914,123107,297459,1047644,38106,986583,758705,198256,708343,156371,957205,289008,114938,767960,274849,962976,559386,953919,1039561,1031158,57787,473395,860520,18736,63436,836335,838548,230469,580382,900218,471803,579522,326965,733390,570810,653296,366947,481084,455944,681166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]