SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499208 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499208 [ RunTime:0.005681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623640,378046,806924,389017,179673,242960,318879,767567,961933,479874,563359,477120,103004,459253,492075,133636,763238,904099,232473,393565,263146,535504,231494,344518,755363,359846,964318,558355,231302,551733,4406,496121,9265,143743,919589,8832,701469,124455,138524,296106,451719,14262,910250,594945,165903,894589,867573,986049,683591,584385,499835,172538,699107,1046896,223969,895560,986467,585186,712391,206183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]