SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981053 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981053 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580291,86673,404711,425727,290922,792166,201848,526107,7559,62321,84561,881003,122173,666378,811067,749763,850209,98166,343894,196228,702610,532200,1000662,845322,885283,958069,739905,299629,582223,594270,175291,286621,729313,23390,806796,278581,385658,363385,899734,334365,289112,556782,86154,647457,619575,743978,392614,321695,526103,456405,55556,85493,646240,859834,696925,702017,739829,770693,699793,333463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]