SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 912843 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 912843 [ RunTime:0.003643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303814,657067,1016518,1040310,279218,291468,348235,133458,633697,1037165,791991,780519,602668,524838,78968,245967,1033589,146062,199044,769695,997689,973886,320076,995651,851227,383651,512648,811320,865083,153454,865080,476206,51109,469786,717171,989714,689867,609965,183257,524696,214747,94074,333664,846887,884246,713079,544003,768231,977384,874099,748601,950859,297421,167128,698152,356822,520560,863349,706165,938450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 912843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 912843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]