SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101501 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101501 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540938,179066,367937,17201,132099,382267,660814,129957,745529,744140,670830,844605,378972,1130,320385,557092,640811,130407,1007112,83484,434993,231700,712681,692768,592562,489114,372401,870319,75868,215536,633025,417429,631960,797852,248055,207115,917913,828061,313115,294362,851408,39644,190878,1044979,53687,74767,964299,89547,527299,986129,895928,741548,103720,782745,128336,825358,796641,920364,943772,719691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]