SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269971 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269971 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445265,1041357,620887,198709,5283,69289,815071,122057,610074,806978,1039114,27033,433378,1038644,763842,600099,191104,340865,788710,926775,515031,720783,216579,955874,215557,283551,965352,658764,233072,445139,967752,732756,742688,209688,434604,821221,958939,273586,550731,699287,978095,1038387,754958,802990,550066,468301,989088,481828,351705,46327,408828,832024,112460,782190,61841,983952,794410,384783,11700,1048152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]