SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002830s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570106 LIMIT 1 [ RunTime:0.002562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570106 [ RunTime:0.002615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362719,86628,456861,498802,684222,374992,547882,436157,814371,24542,847124,220380,807315,443837,489907,620045,894310,756106,14633,510598,273943,402005,27041,872262,884510,140470,608081,155245,313402,640331,289044,885373,792260,759896,458160,524664,204544,775285,916021,375864,1037982,975351,339927,769917,253208,705913,452610,735019,577365,1013164,112207,378862,282928,637710,1019639,988003,614992,211885,931783,567839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.041478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002424s ]