SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 92813 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 92813 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413607,502303,873447,760801,449999,697282,128313,699838,696302,790910,303903,836178,1024967,902405,22639,425066,946040,199789,122978,383806,234358,671178,238532,873541,661793,465376,806553,586382,98157,755998,687794,604078,775357,10519,512536,270428,412367,491331,646176,612222,272720,521335,27678,464656,60834,115446,300557,558599,904139,551517,880738,529327,279318,875773,450826,882374,656735,551421,177302,839743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 92813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 92813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001626s ]