SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710903 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710903 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992953,717718,760231,349177,503765,278752,956103,786910,258521,937042,687621,669146,293459,890870,189284,1001147,490221,583401,740844,175670,256760,988172,84476,642229,297661,868966,397029,473521,810507,769793,335149,662607,535370,251474,102889,712610,995052,238927,545350,961942,192793,309312,744491,605365,841059,211675,114339,758525,742543,104167,253912,350052,718487,666211,508661,132702,177285,781109,311983,73327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]