SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468216 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468216 [ RunTime:0.005544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938682,195248,474074,988807,785338,939804,167617,766422,265518,63397,120004,357163,896447,505825,459208,186177,538280,290328,746975,301846,965992,964485,945307,903158,121972,964794,879698,627560,781376,260303,207442,377316,1048863,452522,652965,393126,894506,792068,954580,460571,196176,151442,167495,540669,975087,70435,736042,674485,956940,218985,888695,243517,320295,420767,269344,318206,79474,488179,616032,278266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]