SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20583 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20583 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460800,131283,65281,642008,190994,373763,600863,550786,29770,361480,714962,308364,305340,1039261,787622,1023411,847886,77851,909785,284027,272503,991686,533781,1027196,924499,833948,315189,801736,588101,1013340,564282,163397,142995,981746,918024,737586,300890,921440,615102,332038,513864,2162,434194,364776,207528,879897,48724,534719,229419,243927,1012297,900223,253336,310828,944692,201427,684135,662899,823390,169985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000822s ]