SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291495 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291495 [ RunTime:0.003739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447956,684141,921210,636670,360605,386957,483866,188650,1032426,452897,1039314,1014723,741859,511112,528887,835862,897296,1030273,219751,314785,186100,608686,781406,1032416,151622,589201,724707,701158,753040,812807,413446,879359,565916,147648,419004,972218,256434,469260,758404,106929,38151,548102,285441,691677,481527,720259,62578,1003263,285207,792456,725790,7218,144025,620124,869994,173688,446748,517401,1020569,245390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]