SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033547 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033547 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314790,69727,1004152,375098,75194,360455,939802,1003480,478353,492632,351248,476410,285106,991547,712303,613566,194713,1032550,572347,451466,439231,323437,297174,933694,711735,141399,430563,1042091,77055,144332,422018,257820,786526,704812,53927,879412,344530,715641,365470,811196,276716,656751,562403,183135,47906,977364,698431,925700,244121,1034672,601924,978156,110244,904831,1032298,148115,455815,388214,1015824,242240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]