SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982108 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982108 [ RunTime:0.002118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205176,525839,202267,1015551,646483,682680,95418,245341,806328,77036,1043068,220400,837770,387680,51467,977834,442826,1005734,985870,677612,553417,853223,291775,178862,51799,721716,795489,649259,975759,344153,609790,153922,566750,729360,1022950,356838,990499,593259,183691,1007397,315774,734275,300466,813287,210827,356026,83866,631501,564906,971164,149965,818193,248090,680435,305963,319398,653978,770320,65039,794094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]