SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39400 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39400 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598497,92816,837288,3572,402500,717916,363073,877274,144067,178822,618576,500405,623256,536058,326875,238198,3781,952137,876227,63049,781980,604110,901866,709725,683119,737444,713057,761450,536085,716368,641613,113343,36668,840343,655214,705582,867211,486734,154902,490341,261773,563474,368930,610839,1020923,310422,944092,207815,274598,983631,853002,235612,441651,242655,17946,914720,102052,788152,241173,372023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]