SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001983s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5740 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5740 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109140,557490,315319,319316,480376,660416,285558,668270,25908,499666,1026013,194813,526565,837975,208289,869975,452991,1024715,458357,618646,868804,1040201,236722,120263,1026197,494561,325130,802461,495083,150509,898812,889082,250400,175732,34018,1002979,204633,578146,211208,46927,1004300,716696,339800,1028399,211037,482953,656493,272627,145440,981672,35222,243687,67991,60756,977580,1046913,319018,175160,299740,361859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001125s ]