SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201393 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201393 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885508,272245,562511,58146,237603,390687,901014,146568,852648,399537,473289,546983,125166,177540,545318,342407,419688,766320,428316,840170,276598,671569,378842,241802,934482,244581,564746,568543,100240,141837,979136,344592,101853,625871,48098,212588,142179,1028544,594399,368323,340901,85294,81793,766350,37851,180572,565659,327386,746413,729256,802388,310704,141360,812928,163689,862122,983939,395302,224427,597616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]