SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573936 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573936 [ RunTime:0.002155s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528736,751747,324796,312051,1027108,410844,277178,69001,36388,198630,1026873,40272,618878,373522,756160,628983,344723,733106,317123,978735,889236,371087,127855,26903,921836,476333,823881,557422,417636,32289,159585,628468,875987,759463,696559,938413,430580,991969,606175,356624,547133,393946,495639,576678,962813,540497,371010,797075,470889,481426,904430,618748,692000,732837,663012,747863,804420,772406,222401,1004109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]