SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547529 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547529 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408252,467568,1023500,439763,880897,699957,884002,571946,1009982,1001717,1017815,458234,297638,855550,359132,1037679,281877,990691,992427,266339,235876,495528,897625,573798,488661,569535,693652,193152,551515,432715,778203,896414,963579,202335,105355,181247,807983,87474,65091,347669,516613,197242,344978,925235,464146,687628,642747,799314,1010245,822251,610311,433141,528843,221194,243840,324087,845015,737054,661341,919577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]