SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198514 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198514 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408207,531923,202518,800847,571491,439300,325987,526254,230725,657664,1002218,455828,789863,530816,552191,934401,395018,673595,1036677,23616,139627,75952,22379,951066,659487,253650,464204,907112,472287,1028376,718420,114612,87122,309424,531851,764827,308269,421040,1011834,639152,737016,158037,712729,413158,1044422,135188,65312,637907,322781,579970,711391,160687,48313,27719,234338,270996,829844,529094,218864,11390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]