SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039578 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039578 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204841,511721,726885,1012495,900059,968954,405424,111633,801573,507837,326755,1008928,56938,860848,990305,343236,896471,538857,391108,395303,805144,36319,39969,723081,634349,968406,181430,847419,352228,807314,1000439,43583,555748,440407,584641,536500,649884,166853,674443,951472,555035,360168,675952,868389,274644,943320,968538,727666,173663,931653,503813,81315,689658,162089,475620,810704,503347,976643,41480,328379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]