SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481328 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481328 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43961,22698,725856,132413,170855,310401,198399,467051,821717,340620,928213,169896,88250,900782,831124,847905,559526,854382,153887,141425,145118,836546,174247,148007,1026158,198292,713711,458131,234730,705666,127284,648925,152698,550132,983872,844809,696829,627332,767517,667277,341269,588623,661023,127725,972334,92917,24404,981287,501635,596475,970166,692629,15853,269556,270827,429131,109927,672004,533929,880528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]