SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403987 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403987 [ RunTime:0.003371s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44632,90240,206815,992622,970170,76286,340898,440132,137580,118364,541339,929393,1021256,109021,243551,1016045,326748,769004,73177,1001034,2201,613070,100844,763418,778933,482163,306578,886690,745161,680661,1010475,844497,215601,239507,102210,665887,567253,678383,610490,815738,81525,270070,785616,284974,211694,828641,842499,18865,598690,810830,258287,72376,297565,322373,727940,784001,991320,235572,527966,541417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]